how to get max salary with employee number by using one select
query and max function ??
Answers were Sorted based on User's Feedback
Answer / suresh jp
select emp_no,max(salary) over() from table_employee;
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / nitin sane
select Employee_name,max(Employee_Salary) over() from Employee_test;
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / mithilesh gatole
Answer -
select MAX(Salary) from Employee
WHERE Salary <> (select MAX(Salary) from Employee )
Is This Answer Correct ? | 0 Yes | 5 No |
Can we use Truncate command on a table which is referenced by FOREIGN KEY?
Can you explain powershell included in sql server 2008?
How to assign new column names in a view?
What are scheduled tasks in sql server?
What is triggers in ms sql server?
What are the pros and cons of creating extended stored procedures?
What is 4nf in normalization form?
Which are the new data types introduced in sql server 2008?
How to use the inserted and deleted pseudo tables?
What is nonclustered index on computed columns?
Explain few of the new features of sql server 2008 management studio
What is the exact numeric data type in sql?