Friday, 27 September 2013

how to see top 5 records in any table

hello friends
Today i will show you how to see top 5 records of any thing suppose you want to see top 5 person name who got good marks in whose total marks in sequence order

you create a table whose name position which fields have s.no. ,name ,sub1m,sub2maks,total
and there are so many records in your table and you want to see top 5 student
so you will write following query in sql server


select top * 5 from postion


Thank you

No comments:

Post a Comment