Home » SQL & PL/SQL » SQL & PL/SQL » group by
group by [message #212747] Mon, 08 January 2007 02:38 Go to next message
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

Re: group by [message #212749 is a reply to message #212747] Mon, 08 January 2007 03:01 Go to previous message
Messages: 20847
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: Fri Oct 28 19:28:25 CDT 2016

Total time taken to generate the page: 0.28576 seconds