Interested to Buy Any Domain ? << Click Here >> for more details...
write query for fourth maximum salary from employee table
- 14 Answers
- 24112 Views
- Mind Tree, SP Software, I also Faced
- E-Mail Answers
Answer Posted / pramod
Select Top 1 (Salary) from emp where salary not in
(select Top 3 (Salary) from emp order by salary desc)
order by salary desc
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Can we call stored procedure in view in sql server?
How to create a trigger for insert only?
What are character string data types in ms sql server?
How is sql server used?
What stored by the master?
define and explain the differences between clustered and non-clustered indexes.
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
What does dml stand for?
what's the information that can be stored inside a bit column? : Sql server database administration
What is CTE in SQL
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
Can you import Microsoft Excel data to SSRS?
How many clustered indexes there can be on table ?
what is a traditional network library for sql servers? : Sql server database administration
What is a view in sql?
