Interested to Buy Any Domain ? << Click Here >> for more details...
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
What is the difference between varchar and nvarchar?
How you would rewrite the sql query to return the customerid sorted numerically?
What is correlated subquery in sql server?
How would you go about developing a ssrs report?
Explain what are page splits? : SQL Server Architecture
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas
How to view the error log for any specific instance? : sql server database administration
Difference between uniqe index and uniqe constraint?
Which are the two editions in which SQL Azure database available?
What is db stored procedure?
How do you manipulate data?
What are the limitations in ssrs on sql server express edition?
How to list all tables in the database using odbc_tables()?
Where is localdb stored?
