• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 501
  • Last Modified:

How to get the last tuple only by SQL?

I have built a table called "Orders" in Access.

I want to use an SQL statement to get the last record of the "Orders", how can I do that?

The primary key of the "Orders" is order_no and its type is text.
0
chuyan
Asked:
chuyan
1 Solution
 
cymbolicCommented:
"Select max(Order_no) from Orders"

then, using returned value

"Select * from Orders where Order_No = <value>

0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now