Interested to Buy Any Domain ? << Click Here >> for more details...
how to get max salary with employee number by using one select
query and max function ??
- 3 Answers
- 8838 Views
- Genpact, I also Faced
- E-Mail Answers
Answer Posted / nitin sane
select Employee_name,max(Employee_Salary) over() from Employee_test;
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the properties of the transaction?
Which tools are available to manage SQL Azure databases and servers?
What language is sql server written in?
How to generate create view script on an existing view?
What is the size of transaction log file?
What is the use of keyword with encryption.
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
What is replication and database mirroring?
what method you can use to reduce the overhead of Reporting Services data sources?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
Why should one not prefix user stored procedures with ‘sp_’?
What are the basic features of a trigger in ms sql server?
how many type of indexing in database?
How to change the password of a login name in ms sql server?
Why would you call update statistics?
