displaying latest 5 values from database table in datagrid

[mavii]

which SQL query will be used to display the last added 4 or values, i want the recent values to b displaed into datagrid as the database i updated daily

[Eduard Keilholz]

SELECT TOP # [fields] FROM [table] Replace # with the maximum number of records to return...

.: I love it when a plan comes together :. http://www.zonderpunt.nl

[Sathesh Sakthivel]

Post your Question in the Suitable Forum.

SSK.

[Sonia Gupta]

sir, i think top # will give the first-n entries. but the question was the last 4 addded records.

Sonia Gupta Soniagupta1@yahoo.co.in Yahoo messengerId-soniagupta1 Love is Friendship and Friendship is Love....

[Md Mustafa]

select top 5 * from table use above query .it will work...

Mohammad Mustafa

[Eduard Keilholz]

Sir, I think you need to invert the order of your result set then... ORDER BY Fieldname DESC This will make sql sort the result set descending on field Fieldname and then pick the top 5 (which is then the latest 5)

.: I love it when a plan comes together :. http://www.zonderpunt.nl