Home » SQL & PL/SQL » SQL & PL/SQL » group by
group by [message #212747] Mon, 08 January 2007 02:38 Go to next message
brihaspatirai
Messages: 24
Registered: November 2006
Location: pune
Junior Member
i want to know the no. of registration per month from registry table plz help me

thanks
Re: group by [message #212749 is a reply to message #212747] Mon, 08 January 2007 03:01 Go to previous message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Jan - 127
Feb - 415
Mar - 223
Apr - 87

You can do the rest.

OK, now seriously: don't expect to be spoonfed. First try to do it yourself, and - if it doesn't work - come back, show us your query and say why do you think it isn't correctly written.

You already know the hint: GROUP BY
Previous Topic: Pro*C to PL/SQL
Next Topic: PLease help with query Need to select distict from one table insert into another
Goto Forum:
  


Current Time: Sat Dec 03 20:37:50 CST 2016

Total time taken to generate the page: 0.14608 seconds