how to find the second highest salary from emp table?
Answer Posted / sudhakar tripathi
select Max(salary) "2nd_Heigh_sal" from employees where
(salary < select Max(salary) from employees);
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is the syntax to add a record to a table?
what are all the different normalizations? : Sql dba
Is left join and outer join same?
What is the use of function "module procedure" in pl/sql?
how many sql dml commands are supported by 'mysql'? : Sql dba
What is t sql in sql server?
what is the command line end user interface - mysql? : Sql dba
What is the largest value that can be stored in a byte data field?
Does postgresql run on the cloud?
What is the difference between execution of triggers and stored procedures?
Can we rollback after truncate?
How many triggers can be applied to a table?
Is primary key is clustered index?
What is query optimization in sql?
Why use triggers in sql?