1. How to fetch all the duplicate records from the table.
2. How to fetch the second highest salary from the table.
Answer Posted / oracle.hemant
select max(salary) from emp where salary<(select max(salary)
from emp)
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Define inner join in sql server joins?
What are the difference between data mart and data warehouse? : sql server analysis services, ssas
What is code near application topology?
Write a sql query to display the current date?
How to test a dml trigger in ms sql server?
What is full outer join in sql server joins?
What do you mean by cardinality?
What information is maintained within the msdb database?
How can a database be repaired?
What factors you will consider calculating the storage requirement for that view?
How do you create type- insensitive operator?
What are the different types of join?
What is difference between sql and sql server?
What is the difference between an index and a unique index?
Why transaction is important?