Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get all details of employee who has maximum
salary from employee table
- 8 Answers
- 16752 Views
- AON, Genpact, I also Faced
- E-Mail Answers
Answer Posted / vj
with cte as
(
select row_number() over (order by employee_salary desc)
maxSal ,* from Employee_Test)
select * from cte where maxSal=1
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
OPTIMIZATION OF SP,CURSOR,TRIGGERS
can any body tell me how to know the password of current user in sql server
What are examples of triggers?
what is a sub-report?
What is resource governor in sql server?
Explain trigger classes i.e. Instead of and after trigger?
What is factless fact table? : sql server analysis services, ssas
Explain about Views?
How we can refresh the view?
Which are the two editions in which SQL Azure database available?
Explain the properties of a relational table?
Explain primary key and foreign key constraints?
Explain log shipping and mention its advantages.
What is the difference between the application object and session object?
How to generate create procedure script on an existing stored procedure?
