sql query to display last 4 records
ASP.NET
2
Posts
2
Posters
0
Views
1
Watching
-
what sql query will be used to display last 4 or 5 records from a table, i want to display the last entered records not all
if using sqlserver or access just select top 5 * from..... order by ID if using mysql use: select * from ... order by ID limit 5 assuming you have an ID autoincrement column (actually it's always better to explicitly state the cilumns you want rather than use * ....)