how to find the second highest salary from emp table?
Answer Posted / sarojkant
select max(salary ) from emp table where sal<(select max
(salary)from emp table)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the plv (pl/vision) package offers?
What makes a good primary key?
What are tables in sql?
what are all types of user defined functions? : Sql dba
Why select is used in sql?
What is the starting oracle error number? What is meant by forward declaration in functions?
Is like operator in sql case sensitive?
Give the order of sql select?
what is normalization? : Sql dba
define join and explain different type of joins? : Sql dba
What is data control language (dcl)?
How run sql*plus commands that are stored in a local file?
What is sqlexception in java?
What are tables and fields in the database?
what is single byte over head in oracle..?