Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

last datarecord

Former Member
0 Likes
609

hallo

how i can read the last data record from database.

is this possible?

regards anujit

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
567

Use MAX key word in your query.

A

hallo

how i can read the last data record from database.

is this possible?

regards anujit

3 REPLIES 3
Read only

Former Member
0 Likes
567

Yes its possible sort the table in descending order and read first one

or you can use read statement and give index of that record

Read only

Former Member
0 Likes
567

If the field is of number data type use aggregate function MAX.

USe Select single and order by in where clause.

Read only

Former Member
0 Likes
568

Use MAX key word in your query.

A