Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Andrzejek on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

last record

Status
Not open for further replies.
chaoma

chaoma

Technical User
Apr 17, 2005
101
US
Does any one know how to get the very last record from the table? Table is not sorted.

Thank you for your assistance.
chaoma
 
Sort by date Sort by votes
Add an autoincrement field to the table (call it ID or something). Then :

SELECT TOP 1 * FROM Table order by ID desc

Bob

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Cpreston
  • Locked
  • Question
Last date per userid 1
Replies
3
Views
150
Andrzejek
Andrzejek
Marclem
  • Locked
  • Question
Get Opinio Last Login Data
Replies
5
Views
189
Andrzejek
Andrzejek
scubafrog79
  • Locked
  • Question
Flag record if there two different locations for that record in another table 1
Replies
3
Views
120
Andrzejek
Andrzejek
ahmedsa2018
  • Locked
  • Question
How to get monther per part id from last date to current date and include remaining date ? 1
Replies
7
Views
199
JohnBayne
JohnBayne
WomanPro
  • Locked
  • Question
Insert into query adds records to unreadable format, how do I change that? 1
Replies
5
Views
275
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top