hi

[sivak]

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

[LizR]

Why?

[ddanbe]

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

[dickersonka]

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

select * from table where idcolumn = max(idcolumn)

[Renukavani]

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

[dickersonka]

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