SQL Last():- it is used to retrieve the last row of the database .
in ms access last() function is present
in sql server we write
if id is present in increasing order then by using this statement we will get last row.
top 1 select the first row and order by id desc means it sorts the row decreasing order.
in ms access last() function is present
in sql server we write
if id is present in increasing order then by using this statement we will get last row.
top 1 select the first row and order by id desc means it sorts the row decreasing order.
No comments :
Post a Comment