how to find the second highest salary from emp table?
Answer Posted / kishor
select max(salary ) from employee
where
sal<(select max(salary)from employee)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
List the ways to get the count of records in a table?
Write a sql select query that only returns each name only once from a table?
What are the different tcl commands in sql?
What are pl sql procedures?
How do I view tables in sql developer?
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews
How to return multiple rows from the stored procedure?
How do I edit a trigger in sql developer?
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
Does sql require a server?
what are the non-standard sql commands supported by 'mysql'? : Sql dba
Can I create table without primary key?
What is offset and limit in sql?
What is the difference between delete and truncate statement in sql?
what are ddl statements in mysql? : Sql dba