How to get DATA using subquery or other thing

Question

0.00/5 (No votes)

See more:

Posted 23-Nov-15 1:27am

Aviinash

Add a Solution

Comments

phil.o 23-Nov-15 7:33am

And what have you tried?

Aviinash 23-Nov-15 7:46am

i have tried both max and groupby but its not working pls help

phil.o 23-Nov-15 7:51am

Please show your query. 'is not working' is not a valid issue description.

Kornfeld Eliyahu Peter 23-Nov-15 7:36am

MAX and GROUP BY

Aviinash 23-Nov-15 7:46am

i have tried both max and groupby but its not working pls help

Arasappan 23-Nov-15 7:49am

both the solutions help u

2 solutions

Solution 1

As Peter pointed out, this is rather easy and a good activity for you to learn. Follow this example:

SQL

SELECT MAX(field1), field2
FROM table1 
GROUP BY field2

This will find the biggest field1 for each field2 since we told it to group field2 together.

Posted 23-Nov-15 1:43am

ZurdoDev

Comments

Arasappan 23-Nov-15 8:06am

5

Add a Solution

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

Arasappan · Accepted Answer · 2015-11-23T01:48:00

Solution 2

SQL

select distinct  a.NAme,max(a.salary) as salary from table_name a group by NAme order by salary desc

SQL

select distinct  a.NAme,max(a.salary) as salary from table_name a group by NAme

Posted 23-Nov-15 1:48am

Arasappan

Updated 23-Nov-15 1:50am

v2

How to get DATA using subquery or other thing

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

How to get DATA using subquery or other thing

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us