Please get the 4 th maximum salary from a table without
using any sql keyword (TOP,MAX are mot allowed)
- 8 Answers
- 11915 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
How to use subqueries with the in operators in ms sql server?
What are the restraints imposed on the table design by a merge replication?
How would we use distinct statement? What is its use?
Explain what is public role in sql server?
How many replicas are maintained for each SQL Azure database?
What Is Rdbms?
Is sql server 2016 free?
If no size is defined while creating the database, what size will the database have?
Explain in details security in SQL azure?
How to loop through result set objects using mssql_fetch_array()?
What are the indexes in sql server?
Is resultset an interface?
Are all views updatable ?
what's the difference between delete table and truncate table commands? : Sql server database administration
What is user defined datatypes and when you should go for them?
