Interested to Buy Any Domain ? << Click Here >> for more details...
how to get max salary with employee number by using one select
query and max function ??
- 3 Answers
- 8844 Views
- Genpact, I also Faced
- E-Mail Answers
Answer Posted / suresh jp
select emp_no,max(salary) over() from table_employee;
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is the difference between a unique key and primary key?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
How to disable a login name in ms sql server?
Name few endpoints exposed by ssrs 2012?
What is Replication?
What causes index fragmentation?
What are the differences between local and global temporary tables?
When is the use of update_statistics command?
What is auditing in sql server?
What is a not null constraint?
What is save transaction and save point?
What is the difference between sdf and mdf?
What are the default system databases in sql server 2000?
What is mscorsvw.exe - process - microsoft .net framework ngen?
