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 different types of database indexes?

1104

How do I determine how many instances of sql server are installed on a computer?

1008

Can multiple columns be used in sql group by clause in ms sql server?

1053

How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

1016

What is unique key constraint?

1064

What is row_number()?

987

How to apply cascading referential integrity in place of triggers?

1036

What is an indice?

1039

What is the difference between primary key and unique constraints?

965

Tell me extended events in sql server 2008?

998

What is a join in sql? What are the types of joins?

1108

What is the difference between clustered and non-clustered indexes in ms sql server?

1003

What is the default port for SQL Server over a firewall?

1101

what are the core components of SSRS?

129

What is temporary table in sql server? Why we use temp table?

957