Answer Posted / moorthy t
select n,* from(select rownum n,* from (select * from table
where group by (sal) order by (sal) desc)) where n=2;
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
How to identify current user in ssrs report?
Can you create a logon trigger in sql server 2005 express edition?
What is the most common type of join?
how we use window authentication connection with sql server.?
What is the meaning of resultset type_scroll_insensitive?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
Define inner join in sql server joins?
What does dml stand for?
Create and insert into temp table in sql server?
What are the purpose of Normalisation?
what is the difference between openrowset and openquery?
What are the pre-defined functions in the sql server?
What is relationship? What number of sorts of relationship are there?
How do you Implement SSIS Packages in your Project?
How to check if a table is being used in sql server?