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 crud methods?
What is the difference between instead of trigger and after trigger?
What are views in sql?
What is the difference between clustered and non-clustered index in sql?
How to run sql*plus commands in sql developer?
How do sql triggers work?
How does sql*loader handles newline characters in a record? : aql loader
Name the operator which is used in the query for pattern matching?
differentiate between float and double. : Sql dba
Difference between truncate, delete and drop commands?
What steps server process has to take to execute an update statement?
what is user defined functions? : Sql dba
What trigger means?
what are all the different normalizations? : Sql dba
Explain lock escalation? : Transact sql
