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
- 16327 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 is the concept of optimization?
Explain the advantages of merge replication?
how can you check the level of fragmentation on a table? : Sql server administration
What are sql azure firewall rules?
You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?
what is a traditional network library for sql servers? : Sql server database administration
How to modify the underlying query of an existing view?
What are the parts of a function?
What do you understand by user-defined function in the sql server?
What is dirty page?
what stored procedure would you use to view lock information? : Sql server administration
What is self contained sub query?
What are the different acid properties?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
How we create SQL Server 2005 Reporting Services ? Give me Sample
