sql query help needs :)

[quad_master]

need some help!!!
i try to display the top 2 rows of last 3 years every month!!! something like this:
yr month name
======= ========= ==========
2008 jan ram
. . .
. . .
2008 dec ram1
2007 jan ram2
. . .
. . .
2007 dec ram3
2006 jan ram4
. . .
. . .
2006 dec ram5

im using a VIEW(from where i get data) & sql server....
plzzzz somebody help me...

happy independance day!!

 

[victor_rambo]

I don't get it with what you posted above!
Give me a sample database structure and data.(give me in SQL form: CREATE TABLE... INSRRT INTO ....)

 

[Bandu]

I never worked with SQL Server, but SQL Server does support something like select top x

So, for you, won't a

Select top 2 from <YOUR_VIEW>

work?