select emp_no,max(salary) over() from table

how to get max salary with employee number by using one select
query and max function ??

Question Posted / suresh jp

Answer Posted / suresh jp

select emp_no,max(salary) over() from table_employee;

Is This Answer Correct ?

7 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the 2 types of classifications of constraints in the sql server?

1048

What is sql or structured query language?

1088

Explain log shipping and mention its advantages.

990

Tell me what is difference between clustered and non clustered index?

897

Is it safe to delete log files?

870

What is the server name in sql server?

959

How to create a new login name in ms sql server?

997

Give me a SQL Query to find out the second largest company?

1122

What is a subquery in a select query statement in ms sql server?

1069

What happens to a statement batch if there is a compilation error?

900

List the various tools available for performance tuning?

845

What is the maximum size of a row in sql server?

908

What does nvl stand for?

907

How to change parameter value inside the report?

153

Explain the difference between primary keys and foreign keys?

944