1. How to fetch all the duplicate records from the table.
2. How to fetch the second highest salary from the table.
Answer Posted / neelu
select max(salary) from employees where rownum<= 2
order by salary desc
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
What is use of attribute hierarchy ordered ? : sql server analysis services, ssas
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
how you can configure a running aggregate in SSRS?
What is subquery? Explain the properties of a subquery?
What is inner join? Explain with an example?
List down some advantages of sql stored procedure?
what is the system function to get the current user's user id? : Sql server database administration
What is the largest component inside a field?
What is ems sql management studio? : sql server management studio
Explain syntax for dropping triggers?
What are database states in ms sql server?
How to write an inner join with the where clause in ms sql server?
Equi join and non equi join is possible with sql server?