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|
What is partition index in sql server?
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
can you instantiate a com object by using t-sql? : Sql server database administration
Can you please differentiate between a primary key and a unique key?
What new changes are being made in SQL Server?
Explain aggregate functions?
What is inner join in sql server joins?
How to determine the service pack currently installed on SQL Server?
wat is mean by normalization?......programing defination i need...(i know basic defination)
What is schemabinding a view?
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
What is factless fact table? : sql server analysis services, ssas