how to get max salary with employee number by using one select
query and max function ??
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
Explain different types of index?
What are the differences between left join and inner join in sql server?
Determine how to use the inserted and deleted pseudo tables?
Can you please differentiate between a primary key and a unique key?
Can we insert data if clustered index is disabled?
What is repeatable read?
What to check if a User database is locked?
When we should use and scope of @@identity?
How do we Backup SQL Azure Data?
Explain indexed views and partitioned view with their syntax.
What are “lock” hints?
What is the difference between rank and dense_rank?
What is the size of transaction log file?
How to update values in a table with update statements in ms sql server?
How do I manually uninstall an instance of sql server 2016?