View previous topic :: View next topic
|
Author |
Message |
naanu
New User
Joined: 02 Jun 2005 Posts: 3
|
|
|
|
hi guys ,
suppose i have one table contain marks in all subjects and his/her name.
if i gave his/her name the result of the query should show the highest marks obtained by her/his in any subject
could you plz help me to write the query
Regads
naaanu |
|
Back to top |
|
|
Pushpak
New User
Joined: 06 May 2005 Posts: 18
|
|
|
|
Hi,
Could you please try following query?
SELECT NAME,SUBJECT,MARKS
FROM XYZ
WHERE NAME = 'A' AND
MARKS IN (
SELECT MAX(MARKS)
FROM XYZ
WHERE NAME = 'A'
);
Pushpak. |
|
Back to top |
|
|
naanu
New User
Joined: 02 Jun 2005 Posts: 3
|
|
|
|
Pushpak wrote: |
Hi,
Could you please try following query?
SELECT NAME,SUBJECT,MARKS
FROM XYZ
WHERE NAME = 'A' AND
MARKS IN (
SELECT MAX(MARKS)
FROM XYZ
WHERE NAME = 'A'
);
Pushpak. |
sorry i think you have not understand the problem correctly
table has name column and subject column like
name mat sci sol lan lan2
my prob is if i gave the name i should get sub on which he got max marks |
|
Back to top |
|
|
Pushpak
New User
Joined: 06 May 2005 Posts: 18
|
|
|
|
Hi,
Could you plz provide more detail ? Like Columns, Data & expected result with value.
Pushpak. |
|
Back to top |
|
|
|