i want to retrieve last record in database with out doing ascending or decending order...can anyone tell me what query for this?

Why?

Put a timestamp field in your table and use a query to get the record with the most recent timestamp.

either timestamp or as long as you are doing inserts with an autoincrementing id

select * from table where idcolumn = max(idcolumn)

hi
u can use this way also

select max(id) from tablename

if u r insert records automatic way or(autogenerate id) means this is useful

thats what i wrote, he said record, thats why i selected the whole row

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.