how to find the second highest salary from emp table?
Answer Posted / udayalakshmij
select emp_name,max(salary) from emp except(select max(salary) from emp);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how to include numeric values in sql statements? : Sql dba
What is snowflake sql?
What is nosql vs sql?
what are date and time data types? : Sql dba
Write an sql query to select all records from the table?
What is the largest value that can be stored in a byte data field?
How many unique keys can a table have?
What are stored procedures used for?
what are the non-standard sql commands supported by 'mysql'? : Sql dba
How to handle bulk data?
How do you update a table in sql?
Define tables and fields in a database
What is left inner join in sql?
How can we optimize a sql query?
What are the types of triggers in sql?