how to compare between columns

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

Pushpak · New User Joined: 06 May 2005 Posts: 22

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.

naanu · New User Joined: 02 Jun 2005 Posts: 3

Pushpak · New User Joined: 06 May 2005 Posts: 22

Hi,

Could you plz provide more detail ? Like Columns, Data & expected result with value.

Pushpak.