how to find the second highest salary from emp table?
Answer Posted / anonymous
select Max(salary) from test where salary not in(select Max
(salary) from test);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the use of %rowtype?
Explain the advantages and disadvantages of stored procedure?
What are triggers in sql?
What is the difference between a query and a report?
who introduced sql?
Sql technical questions
What is the use of primary key?
What are the advantages of pl sql?
what are the features and advantages of object-oriented programming? : Sql dba
what does the t-sql command ident_current does? : Transact sql
what is 'mysqladmin' in mysql? : Sql dba
What is user in sql?
explain the difference between bool, tinyint and bit. : Sql dba
What is t-sql? : Transact sql
what are different types of collation sensitivity? : Sql dba