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
What is the maximum number of columns in sql table?
What is attribute indicator in pl sql?
Can I learn sql in a week?
Is vs as in pl sql?
How many triggers can be applied to a table?
how can we know the count/number of elements of an array? : Sql dba
Why schema is used in sql?
What is the purpose of design view?
what are enums used for in mysql? : Sql dba
How do you update sql?
Which function is used to return remainder in a division operator in sql?
Is the primary key an index?
What is a mutating table and a constraining table?
Give the order of sql select?
What do you think about pl/sql?