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 |
How do you pronounce sql?
What are three advantages to using sql?
What is difference between function and trigger?
write a query to delete similar records in particular fields(columns) in different tables
How many sql are there?
Explain what is a field in a database and record in a database?
What is a table?
What is sql data?
Write a query to genarate target column.Please answer me. Advance Thanks. Src Tgt Q10 Quarter to 2010 Q90 Quarter to 1990 Q80 Quarter to 1980 Q74 Quarter to 1974
Is drop table faster than truncate?
What is the maximum size of sqlite database?
i have a table with column sno with 30 records. i want to update this column by item by item in asp.net. i wantto enter new values into that from 1 to 30 how is it possible with backend c#