Table name: T1, it has only one column.
col1
------
c
b
a
b
b
b
b
d
s
a
a
t
s
Requirement:
I need the following output from the above base table by
using SQL query.
col1 Cnt
----- -------
a 3
b 5
Others 5
Please help.
Thanks
Guru
v.gurus@in.com
Answers were Sorted based on User's Feedback
Answer / vinu
select decode (col1,'a','a','b','b','others') col1,count(col1) from T1 group by decode (col1,'a','a','b','b','others')
Is This Answer Correct ? | 9 Yes | 2 No |
Answer / vikneswaran
select decode(col1,'a','a','b','b','Other') "col1",count
(col1) "countval"
from col group by decode(col1,'a','a','b','b','Other');
Is This Answer Correct ? | 1 Yes | 0 No |
select name ,count(name)as cnt from (
select case when ((name ='a') or (name = 'b') )then name
else
'others' end as 'name' from tbl_count ) as temp group by
name
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sandhya
SELECT col1, count(*) cnt
FROM T1
GROUP BY col1
ODER BY col1
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / vivek nagarajan
SELECT SUM(DECODE(txt,'a',1)) a_count,
SUM(DECODE(txt,'b',1)) b_count,
SUM(DECODE(txt,'a',0,'b',0,1)) others_count
FROM t1;
Is This Answer Correct ? | 2 Yes | 2 No |
Answer / kumarvijay
select decode(dept_id,1,1,2,2,0) "cnt" ,count(decode
(dept_id,1,1,2,2,0))
from deps group by decode(dept_id,1,1,2,2,0);
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sankarapandian
SELECT SUM(case when col1='a' then 1 else 0 end) a_count,
SUM(case when col1='b' then 1 else 0 end)
b_count,
sum(case when col1!='a' and col1!='b' then 1
else 0 end)other_count
FROM t1
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / vikneswaran
select decode(col1,'a','a','b','b','Other') "col1",count
(col1) "countval"
from col group by col1;
Is This Answer Correct ? | 0 Yes | 2 No |
Answer / purushotham
SELECT PROD_CODE ,COUNT(1) FROM TFT_P_PROD WHERE
BRCH_CODE='784'
GROUP BY PROD_CODE;
Is This Answer Correct ? | 0 Yes | 3 No |
Explain 3 basic parts of a trigger.
What is the example of procedure?
How do we use distinct statement? What is its use?
What is PL/SQL table ?
can i call procedure in package
What is a database? Explain
What is ON DELETE CASCADE?
What is bind reference and how can it be created?
What is rtm stands for?
Can any one tell me how to increase the performance of a sql query ie what are the performance tips in creating or writing a sql query !!?
how can we submit a form without a submit button? : Sql dba
sales persons should always receive commission of 100 at least. employees who r not sales persons should never receive commission.(Triggers)