SQL Shortel Abandoned Calls Query

Question

I am tring to query a table and it doesnt seem to be working. can anyone assist?

SELECT     ExitReason AS CallsAbandoned
FROM         queuecall
WHERE     (ExitReason = 7) THEN
                  (ExitReason = 1 ELSE
                  (ExitReason = 0)))

The deninition or outcome i am looking for is:

if {ExitReason} = 7 THEN 1 ELSE 0

I am not sure how complete the right query.

Thanks, Arron

Linger · Accepted Answer · 2013-12-05T15:34:27.767

1

The following is what you are looking for:

SELECT CASE WHEN ExitReason = 7 
       THEN 1 
       ELSE 0 
       END AS CallsAbandoned 
FROM queuecall

Or if you are wanting a count of the result of the CASE then try the following:

SELECT SUM(CASE WHEN ExitReason = 7 
       THEN 1 
       ELSE 0 
       END) AS CallsAbandoned 
FROM queuecall

edited Dec 05 '13 at 15:34

answered Dec 05 '13 at 15:22

Linger

14,942
23
52
79

Ramesh · Answer 2 · 2013-12-06T04:14:38.117

0

Try this:

 SELECT IF(EXITREASON = 7, 1, 0) AS CallsAbandoned 
FROM   QUEUECALL

SQL FIDDLE : http://sqlfiddle.com/#!2/56a1d/1

edited Dec 06 '13 at 04:14

answered Dec 05 '13 at 15:31

Ramesh

1,872
2
20
33

Guys. This Query did not work for me. The above query linger provided was a validated query for me. I Didnt what to leave you guys hanging. – Arron Robles Dec 05 '13 at 15:59
Yes, Msg 156, Level 15, State 1, Line 1 Incorrect syntax near the keyword 'IF'. Msg 102, Level 15, State 1, Line 1 Incorrect syntax near ','. – Arron Robles Dec 05 '13 at 16:37
Are you using Mysql? Which version – Ramesh Dec 06 '13 at 04:07
I am using SQL2012 and Navicat for MySQL. – Arron Robles Dec 06 '13 at 05:32
let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/42623/discussion-between-ramesh-and-arronrobles) – Ramesh Dec 06 '13 at 05:49

SQL Shortel Abandoned Calls Query

2 Answers2