Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / vamsi krishna
For 2nd maximum salary
select Max(sal) from EMP a where 2=(select COUNT(distinct(sal)) from EMP b where a.SAL<=b.SAL);
| Is This Answer Correct ? | 14 Yes | 3 No |
Post New Answer View All Answers
What is sql azure database?
What is the primary use of the model database?
What is partition index in sql server?
What new data source types were added in ssrs 2014?
How to create database with physical files specified in ms sql server?
What is precedence constraint?
What is the template in sql?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
What is sql injection? How to protect against sql injection attack?
What are the different Topologies in which Replication can be configured?
How to connect Azure federated root database and apply federation in entity framework?
What is set nocount on and what is set nocount off?
Difference between Logical Page and Physical Page in SSRS.
how can a database be repaired? : Sql server administration
How to manipulate data from one table to another table ?
