Answer Posted / nilesh
hi all,
This will also work fine, try it
select top 1 * from (select top 2 * from table_name)as set
order by set.col_name desc
here table_name is the name of the table from which
you want to retrive the record.
And col_name is the column name by which you are sorting
the records
If it found wrong plz correct it....
and show it on this site
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
what are rollup and cube in t-sql? : Transact sql
What is pls integer?
How are sql commands classified?
Is drop table faster than truncate?
How many developers work on postgresql?
What is pl sql quora?
what are aggregate and scalar functions? : Sql dba
what are the different index configurations a table can have? : Sql dba
What are the benefits of triggers?
What are local and global variables and their differences?
What is the difference between a primary key and a unique key?
What is the difference between jpql and sql?
what are the different type of sql's statements ? : Sql dba
How do you identify a primary key?
What is difference between stored procedures and application procedures?
