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: 21148
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: execution of procedure in trigger
Next Topic: Advanced queries in sql
Goto Forum:

Current Time: Tue Aug 22 15:52:36 CDT 2017

Total time taken to generate the page: 0.04277 seconds