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 |
How many ways to create table-valued functions?
What is xdr?
What is coalesce and check constraint in sql server?
How to create a dynamic cursor with the dynamic option?
Psudo colums
Do you know spatial data types - geometry and geography in sql server 2008?
What specific conditions database should meet, before you can bulk copy data into it using bcp?
What is pessimistic concurrency?
What are the new data types are introduced in sql 2000?
Difference between Function and Stored Procedure?
what is normalization? Explain different levels of normalization? : Sql server database administration
what is the system function to get the current user's user id? : Sql server database administration
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)