Interested to Buy Any Domain ? << Click Here >> for more details...
Please get the 4 th maximum salary from a table without
using any sql keyword (TOP,MAX are mot allowed)
- 8 Answers
- 13210 Views
- I also Faced
- E-Mail Answers
Answer Posted / sumathy
Create Table 'Employee' with columns 'Emp_Name'
and 'Salary'. And, Insert some data.....
Cursor:
declare Cursor_Name cursor scroll
for select salary from Emploee order by salary desc
open Cursor_Name
fetch absolute 2 from Cursor_Name
deallocate Cursor_Name
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Why do we need different type of parameter?
Give main differences between "Truncate" and "Delete".
What are the two modes of authentication in sql server?
Explain system views?
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
What is policy management?
Explain what are the events recorded in a transaction log?
Explain where clause?
What does COMMIT command do?
What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration
What do you mean by an execution plan? How would you view it?
Explain Geography datatype in SQL Server
what is the information that can be stored inside a bit column? : Sql server database administration
Explain trigger and trigger types?
When multiple after triggers are attached to sql table, how to control the order of execution?
