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
- 13266 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
ow to bring suspect mode datbase online from scratch
How to convert numeric expression data types by assignment operations?
What do you need to connect php to sql server?
What are extended events in sql server?
What is the difference between coalesce() & isnull()?
What are the functions in sql server?
What is difference between joins and subqueries?
What is molap and its advantage? : sql server analysis services, ssas
What is the data type of time?
How is SQL Azure different than SQL server?
what protocol both networks use? : Sql server database administration
How to convert numeric expression data types using the cast() function?
What is data compression?
Is resultset an interface?
What will be the maximum number of index per table?
