SQL Query to select the name and no.of occurrence

arindambanerjee · New User Joined: 30 Jun 2007 Posts: 39 Location: India

Hi All,

I have a TABLE with the following structures:
T1(table name).

NAME Date
A 05/10/1998
B 05/05/2003
B 07/12/2008
A 09/07/2009
C 03/11/1994
A 13/10/1997
C 11/11/2008
My output required is:
A 3 09/07/2009
B 2 07/12/2008
C 2 11/11/2008
I.e. I need the name, no.of occurrence and the latest date associated with the Names.

Can we discuss this SQL query?

bhairon singh rathore · New User Joined: 19 Jun 2008 Posts: 91 Location: banglore

Select Name,count(*) as count,Max(Date) from TABLE
group by Name