can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
Answer Posted / tulasi ravi kumar
hi,
my id is ravi106109@gmail.com
select sal from emp a
where 1=(select count(b.sal) from emp b
where a.sal<b.sal) order by sal desc;
and also dileep is write
Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
What is the sql profiler?
Explain what are the restrictions while creating batches in sql server?
Does sql server 2000 clustering support load balancing?
What are the types of processing and explain each? : sql server analysis services, ssas
What is the primary use of the model database?
What is stored in the mssqlsystemresource database? : sql server database administration
What is the difference between primary key and unique constraints?
1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do
How to create new table with "create table" statements?
please differentiate between delete and truncate?
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
Explain different types of lock modes in sql server 2000?
What are exact numeric data types in ms sql server?
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
What are the two authentication modes in sql server?