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
- 16624 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
What are logical database components? : SQL Server Architecture
What are user defined functions in ms sql server?
What is acid properties?
What are the different types of Indexes available in SQL Server?
What happens when converting big values to integers?
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
Where are sql server user names and passwords stored in sql server?
what are the different types of SSRS reports?
Can an entity have two primary keys?
What are the differences between substr and charindex in sql server.
What is a trigger what are the advantages of trigger?
Hi all, can any one please tell me the difference between sql server 2008 and orace 9i
What is the importance of concurrency control?
What is star, snowflake and star flake schema? : sql server analysis services, ssas
Explain transaction server auto commit?
