Interested to Buy Any Domain ? << Click Here >> for more details...
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 conditional predicates?
What is rank () in sql?
What is sql*plus?
What is pls integer?
What is the difference between instead of trigger and after trigger?
How much does sql cost?
what are the differences between binary and varbinary? : Sql dba
Why do we need pl sql?
What is a nested table in word?
What is sql architecture?
What is lexical units in pl sql?
How do you clear the screen in sql?
can a stored procedure call itself or recursive stored procedure? : Sql dba
What is the reports view in oracle sql developer?
What happens when a trigger is associated to a view?
