how to find the second highest salary from emp table?
Answer Posted / bharat puri
select top 2 (salary) from emp
order by salary desc
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Is sql a programming?
what is the difference between clustered and non clustered index in sql? : Sql dba
How many types of primary keys are there?
what is the difference between truncate and delete statement? : Transact sql
What does where 1 1 mean in sql?
What is record in pl sql?
Which one is faster ienumerable or iqueryable?
what are the difference between clustered and a non-clustered index? : Sql dba
What are the various levels of constraints?
What is a composite primary key?
What is sqlite format?
What kind of join is join?
How do I save the results of sql query in a file?
Can a commit statement be executed as part of a trigger?
Which sql statement is used to return only different values?