how to find the second highest salary from emp table?
Answer Posted / sathiavathi
select max(salary) from employee where salary!=(select max
(salary) from employee);
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Is it possible to update views?
What are some predefined exceptions in pl/sql?
what are the properties and different types of sub-queries? : Sql dba
How do you declare a constant?
which operator is used in query for pattern matching? : Sql dba
How do I find duplicates in a single column in sql?
What is trigger in sql? Explain
What are dml commands?
How do you explain an index number?
Does sap use sql?
What are sql procedures?
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
What is difference sql and mysql?
how to rename an existing table in mysql? : Sql dba
What is the plv (pl/vision) package offers?