Returning Last 3 records

[gi11ies]

Im wondering how I return the last three records in any table?

Any help would be great

Gillies

 

[ZmrAbdulla]

It depends to the Primary Key field.
Set a query like

SELECT TOP 3 tblIssue.IssueID
FROM tblIssue
ORDER BY tblIssue.IssueID DESC;

________________________________________________________
Zameer Abdulla
Help to find Missing people
Do not cut down the tree that gives you shade.

 

[Golom]

Tables in a relational database do not have any inherent ordering of records so the term "last three" has meaning only in respect of some some particular ordering that you define for the table. The usual way is something like

Select TOP 3 fld1, fld2, fld3, ...
From tbl
Order By fld1, fld2;

and you specify the Order By clause to bring the three records that you want to the top of the list.