Interested to Buy Any Domain ? << Click Here >> for more details...
can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
- 28 Answers
- 32423 Views
- IBM, Symphony, I also Faced
- E-Mail Answers
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 can delete duplicate records in cte in sql server?
what is datawarehouse?
What is difference between joins and subqueries?
How ssrs maintain security?
Who is the owner of a schema in ms sql server?
List down some advantages of sql stored procedure?
Write a SQL query in order to merge two different columns into single column?
List layers of abstraction microsoft architectured to provide relational db through cloud platform ?
Indexes are updated automatically is the full-text index also updated automatically?
what is package and it uses and how can u call a package
How to install sql server 2005 express edition?
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 can you start sql server in different modes?
What is a schema in ms sql server 2005?
List few advantages of stored procedure.
