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
15347 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

Explain about various levels of constraint.

0 Answers

Can you inner join the same table?

0 Answers

What problem one might face while writing log information to a data-base table in pl/sql?

0 Answers

What is a trigger in pl/sql?

1 Answers

Does sql require a server?

0 Answers

hi..........i m Accenture employee...Accenture is an IT company having itz branches in India at Mumbai, Pune,Delhi, Hyderabad, Chennai and Bangalore....Presently there are openings here for SAP, Testing, Oracle,Java,.NET,MAinframe and Peoplesoft...... I am a software engineer working with Accenture,Mumbai....u can mail me in your resume..i`ll forward it to our HR team...my mail id: pankit.lodaya@accenture.com

8 Answers Wipro,

What can be a size of a pl/sql block? Is there any limit?

2 Answers

How can get second highest salary in sql?

0 Answers

What is function and procedure in pl sql?

0 Answers

What is a pdo connection?

0 Answers

Show code of a cursor for loop.

0 Answers

Display the total debit counts, total credit counts, sum of total debits, sum of total credits from an employee's transaction table (a single table) containing the following columns. Transaction_number Transaction_amount Transaction_date Transaction_type --> tells if the amount is a credit or a debit. As the query alone is important, the table is left with specifying just the field's name. Pls help me with this query.

3 Answers iNautix, Oracle,

For more SQL PLSQL Interview Questions Click Here