how to find the second highest salary from emp table?
Answer Posted / parvezkhan pathan
select max(salary) from emp where salary not in(select
max(salary) from emp);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how to enter characters as hex numbers? : Sql dba
Describe different types of general function used in sql?
What is write ahead logging in sql server?
Can a primary key be a foreign key?
Why do we use subquery?
How many types of triggers are there in pl sql?
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
Are stored procedures faster than queries?
Which software is used for pl sql programming?
write an sql query to find names of employee start with 'a'? : Sql dba
How do I remove duplicates in two columns?
What is difference between left and right outer join?
What are the 3 modes of parameter?
What is the difference between left join and right join?
Does pl sql work in mysql?