finding the highest salary in a table

Question

0.00/5 (No votes)

See more:

SQL

select * from emp m where(select COUNT(distinct salary) from emp s where s.salary>m.salary)=0

can any one tell me what is the execution flow

[edit]code block fixed[/edit]

Posted 15-Dec-12 22:06pm

Member 9560415

Updated 15-Dec-12 22:14pm

Nelek

v2

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Pablo Aliskevicius · Answer 1 · 2012-12-16T01:26:00

In SQL Server Management Studio, you can show the execution plan. Click Ctrl+M, or from the menu, choose 'Query|Include Actual Execution Plan'.

This will vary depending on your table structure (which indexes are available), your table contents (statistics), your server hardware (RAM, number of CPUs), and your server load (the server will invest more resources building a plan if more resources are available).

So the only one who can tell what is the execution plan is you.

Good luck,
Pablo.

Tarun Mangukiya · Answer 2 · 2012-12-16T02:44:00

Solution 2

I think that you can use MAX function...

For Example:
Select MAX(coloumn_name) from table_name;

Thanks.

Posted 16-Dec-12 2:44am

Tarun Mangukiya

Comments

Sk. Tajbir 16-Dec-12 14:16pm

5+

Sk. **Tajbir** · Answer 3 · 2012-12-16T08:15:00

Solution 3

You can use this query with Max function like Mr. Tarun said,

SQL

select * from emp where salary = (select Max(salary) from emp)

This is will give you a list of employees who have highest salary.

I hope this will work.
Thanks :)

Posted 16-Dec-12 8:15am

Sk. Tajbir

Comments

Tarun Mangukiya 16-Dec-12 23:24pm

Ya.
The same Query we can use.
But I can't suggest him because he has to learn all this himself.
So, I just gave an example...

Thanks.

Sk. Tajbir 17-Dec-12 2:07am

ok :)