Home » SQL & PL/SQL » SQL & PL/SQL » query needed
query needed [message #225198] Mon, 19 March 2007 01:39 Go to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member

HI,

I want one sql query .Anybody help to me..

table structure:

name age

nicols 34
edwin 27
connors 34
joseph 55
bright 34

expecting output:

age count(*)

34 ---> 3
27 ---> 1
55 ---> 1

anybody ...

regards,
arun..
Re: query needed [message #225199 is a reply to message #225198] Mon, 19 March 2007 01:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64101
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

I advice you to read a basic SQL book.
Have a look at:
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_10002.htm#i2182483

Regards
Michel

Re: query needed [message #225201 is a reply to message #225198] Mon, 19 March 2007 01:53 Go to previous messageGo to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member


i want query ..

Regards,
Arun
Re: query needed [message #225202 is a reply to message #225201] Mon, 19 March 2007 01:55 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
.. and I want a new laptop.
Re: query needed [message #225204 is a reply to message #225202] Mon, 19 March 2007 02:22 Go to previous message
pavuluri
Messages: 247
Registered: January 2007
Senior Member
select count(*) as agecount ,age from table group by age

thanks
srinivas
Previous Topic: CALL Store Procedure with Output variable from Another Procedure
Next Topic: Correct SQL?
Goto Forum:
  


Current Time: Fri Dec 02 13:52:47 CST 2016

Total time taken to generate the page: 0.09062 seconds