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
Explain full-text indexing?
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
What are the operating modes in which database mirroring runs?
What can be used instead of trigger?
What is the full meaning of dml?
How do I create a trace in sql server?
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
What is the difference RDBMS and Graph Database?
Write a SQL command to insert and update only a particular field?
How to recompile stored procedure at run time?
Define outer join?
Write a SQL queries on Self Join and Inner Join.
What are sub reports and how to create them?
What is sql server 2000 work load governor?
Does sql server 2016 have ssms?
