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 ?||4 Yes||0 No|
Answer / nitin sane
select Employee_name,max(Employee_Salary) over() from Employee_test;
|Is This Answer Correct ?||1 Yes||0 No|
Answer / mithilesh gatole
select MAX(Salary) from Employee
WHERE Salary <> (select MAX(Salary) from Employee )
|Is This Answer Correct ?||0 Yes||5 No|
How to write query to Delete the records in child table and corresponding records in parent table
What is the SQL?????????????????????????????
What happens if an integer is too big for int date type?
What types of integrity are enforced by a foreign-key constraint
When is the use of update_statistics command?
Display a roll having miminum marks in two subjects?
Explain microsoft sql server functions?
What is attribute relationships, why we need it? : sql server analysis services, ssas
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
Explain how many types of relationship?
how to generate XML out of QUERY?