HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY
IN EMP TABLE
Answer Posted / kumari
SELECT TOP (3)with ties empsalry
FROM empsalr
order by empsalry desc;
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
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
What are rows and columns?
Where are sql server usernames and passwords stored in the sql server?
what is unique and xaml nonclustered index
what is hash nonclustered index
Explain about Joins?
What is the difference between the 2 operating modes of database mirroring?
Explain boyce and codd normal form(bcnf)?
What is proper subset of candidate key?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
What are the differences between decimal and float in ms sql server?
what authentication modes does sql server support? : Sql server database administration
What is normalization and what are the advantages of it?
what is database replicaion? : Sql server database administration
What are the advantages of partitioning?