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 happens when a trigger is associated to a view?
What are the types of join and explain each?
How do I create a memory optimized filegroup?
How do I order by ascending in sql?
How do you delete a table?
what are the t string functions available in tsql? : Transact sql
What are aggregate and scalar functions?
What is composite data type in pl sql?
Can we use pl sql in mysql?
What is the difference between function and procedure in pl/sql?
What is difference between pls_integer and integer?
What is query syntax?
How many rows can sqlite handle?
What is nvarchar in sql?
Can we use commit inside a trigger?
