how to find the second highest salary from emp table?
Answer Posted / karthik.k
select max(salary) as second_highest from emp where salary
< (select max(salary) from emp)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are pl sql procedures?
Explain the update statement in sql
How delete a row in sql?
what is “go” in t-sql? : Transact sql
difference between anonymous blocks and sub-programs.
What are the parts of a basic sql query?
Write an sql query to select all records from the table?
What does a pl/sql package consist of?
What will you get by the cursor attribute sql%rowcount?
What is consistency?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
What is crud sql?
what is the difference between blob and text? : Sql dba
What is rowtype?
What is forward declaration in pl sql?