OraFAQ Forum: SQL & PL/SQL » Need answer to this Query

Home » SQL & PL/SQL » SQL & PL/SQL » Need answer to this Query (Oracle 10G AS)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Need answer to this Query [message #437904]

Wed, 06 January 2010 08:42

gurusuryas
Messages: 49
Registered: March 2009
Location: Chennai

Member

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
Gurus

Report message to a moderator

Re: Need answer to this Query [message #437906 is a reply to message #437904]

Wed, 06 January 2010 08:45

cookiemonster
Messages: 13973
Registered: September 2008
Location: Rainy Manchester

Senior Member

By my reckoning others should be 7 not 5.
You can do this easily using a combination of count, case and group by.

Report message to a moderator

Re: Need answer to this Query [message #437913 is a reply to message #437904]

Wed, 06 January 2010 09:04

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

1/
lease read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.

2/
Also always post your Oracle version with 4 decimals.

3/
Post a workingTest case: create table and insert statements along with the result you want with these data.

4/
Quote: