Table name: T1, it has only one column. col1 ------ c b a b b b b

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

Question Posted / gurusuryas

11 Answers
15865 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Table name: T1, it has only one column. col1 ------ c b a b b b b d s a a t s ..

Answer / dinakar

select col1,count(*) cnt from T1 where col1 in
(select distinct col1 from T1 )
group by col1

Is This Answer Correct ?

1 Yes

6 No

Post New Answer

More SQL PLSQL Interview Questions

what is the difference between cursor FETCH and FOR LOOP ?

3 Answers CG-VAK, Tech Mahindra,

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

0 Answers

Explain the methods used to protect source code of pl/sql.

0 Answers

Name Salary Abc 50000 Abc 50000 xyz 20000 find the max salary using aggregate function?

2 Answers CTS,

Can we create view in stored procedure?

0 Answers

What is Highwatermark?

3 Answers Thermotech,

What is data manipulation language?

0 Answers

How to write html code in pl sql?