Member Avatar for MARKAND911

How to use TOP(1) keyword in MS Access query.

select * TOP(1) from mytable orderby mycolumn desc;

this querry gives me error;

Any other alternate to implement this code;

  • 2 Contributors
  • 1 Reply
  • 92 Views
  • 1 Month Discussion Span
  • Latest Post Latest Post by priyasudhakar
Member Avatar for priyasudhakar

Please use this query for selecting last record
select top 1 * from table_name order by columnname desc
if the columnname is id of the table
BY
priyasudhakar

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.