query for ordering

query for ordering

 

  

Hi all,
I am very new to db2 and want to know about this simple query.
I have a table where there are 3 groups of items.I want to select the top
3 items in each group.I tried using count() but the query is not working.
please revert back with some possible queries.

Thanks and regards,
Madhu


DB2 & UDB email list listserv db2-l LazyDBA home page