how to find the second highest salary from emp table?
Answer Posted / naveen r kumar
SELECT Max(salary) FROM TABLE
WHERE salary NOT IN (SELECT Max(salary) FROM TABLE);
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Is it possible to link two groups inside a cross products after the cross products group has been created?
Name the different types of indexes in sql and define them.
explain the delete statements in sql
How to add new employee details in an employee_details table with the following details
what is the difference between cluster and non cluster index? : Sql dba
What are the qualities of 2nf?
give the syntax of grant and revoke commands? : Sql dba
Explain autonomous transaction.
Is left join same as inner join?
how would you enter characters as hex numbers? : Sql dba
Can I copy :old and :new pseudo-records in/to an oracle stored procedure?
discuss about myisam index statistics collection. : Sql dba
What is the difference between a database and a relational database?
What is the location of pre_defined_functions.
What is the file extension for sql database?