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;

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

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.