how to find the second highest salary from emp table?
Answer Posted / sreenadh reddy
select max(sal) from emp where sal <(select max(sal) from
emp)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are the join types in tsql? : Transact sql
What is a pl/sql block?
How do you concatenate in sql?
What is sql used for?
How can I delete duplicate rows?
How do I pipe the output of one isql to another?
What does pragma mean?
How do I use google cloud in sql?
What are views in sql?
what are the different functions in sorting an array? : Sql dba
What is basic structure of pl sql?
What is sql scripting?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
what happens if you no create privilege in a database? : Sql dba
What does seeding a database mean?