Interested to Buy Any Domain ? << Click Here >> for more details...
How to find 6th highest salary from Employee table ?
- 10 Answers
- 24411 Views
- I also Faced
- E-Mail Answers
Answer Posted / rahul gupta
select sal from employee e1 where 5 = (select count(*) from
employee e2 where e1.sal < e2.sal)
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
What are the five major components of a dbms?
Can foreign key be deleted?
What is triggers and stored procedures?
How to update values in a table with update statements in ms sql server?
What is exporting and importing utility?
What are the grouping functions?
What is the difference between set and select?
Why do we need different type of parameter?
List out the difference between union and union all in sql server?
what type of index will get created after executing the above statement? : Sql server database administration
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
What types of replication are supported in sql server?
what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
How to test a dml trigger in ms sql server?
What is best institute to Learn DotNET And SQL in chennai?
