Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / srinath reddy
select * from emp e1 where 3 = (select count(*) from emp e2
where e1.salary <= e2.salary);
instead of answer we can say this as a solution where we can
find nth also
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Write a sql query to find the names of employees that begin with ‘a’?
What are the query optimization techniques?
What is a heap in sql?
Is a foreign key always unique?
What is clause in sql?
What is auto increment feature in sql?
Can we use update in sql function?
What's the difference between inner join and left join?
what is sub-query? : Transact sql
What are the types of variable use in pl sql?
Where is sql database stored?
How to run sql commands in sql*plus?
what is a relationship and what are they? : Sql dba
Explain scalar functions in sql?
What is an oracle stored procedure?
