shamimaziz

 Profile Answers by shamimaziz 

• Jul 21st, 2007

 

From ASE 12.5.3
select top 1  * from <tablename> order by <key>  desc

Prior ASE 12.5.3

set rowcount 1
select top 1  * from <tablename> order by desc
set rowcount 0 ( this will reset the option you set)

jdx

• Aug 7th, 2007

 

select  * from <tablename> where <key> = (select max(<key>) from <tablename> )

gcvpgeek

 Profile Answers by gcvpgeek 

• Mar 4th, 2009

 

Use the below query

select * from table1 minus select * from table1 where rownum < (select count(1) from table1)

efficasy

 Profile Answers by efficasy 

• Mar 8th, 2009

 

Set rowcount 1
Select col_name from table_name order by col_name desc