can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
Answer Posted / harikumar
select max(salary) as secondMax from employee where id <>
(select max(salary) from employee)
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How many non clustered indexes there can be on table ?
What is an execution plan? When would you use it?
What is the index requirement in SQL Azure?
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.
When I delete any data from a table, does the sql server reduce the size of that table?
What is the security principal at the server level that represents your session?
What are the fixed server level roles? : sql server security
What are commonly used mssql functions in php?
Do you know exporting and importing utility?
How to recover from sql injection? : sql server security
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
What is the bookmark lookup and rid lookup?
What are the differences between char and varchar in ms sql server?
Why variables called the most powerful component of ssis?
What are the purposes and advantages stored procedure?