Interested to Buy Any Domain ? << Click Here >> for more details...
write query for fourth maximum salary from employee table
- 14 Answers
- 23919 Views
- Mind Tree, SP Software, I also Faced
- E-Mail Answers
Answer Posted / prabhjeet singh sethi
select * from
(select rank(salary) over (partition by employee order by salary desc) as top_salary, employee from table
group by employee)
where top_salary = 4
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is normalization and what are the advantages of it?
What is user-defined functions? What are the types of user-defined functions that can be created?
Difference between primary key and clustered index?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
What is the status of services on passive node for failover cluster in sql server? : sql server database administration
What is normalization 1nf 2nf 3nf?
How will you add a dimension to cube? : sql server analysis services, ssas
What do you mean by authentication modes in sql server?
What are system databases into sql server (2005/2008) : sql server database administration
What is report snapshot?
While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?
Explain go command in sql server?
What is a result set object returned by odbc_exec()?
How to create user defined functions with parameters?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
