Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

how to compare between columns

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
naanu

New User


Joined: 02 Jun 2005
Posts: 3

PostPosted: Tue Jun 07, 2005 9:21 am    Post subject: how to compare between columns
Reply with quote

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
View user's profile Send private message

Pushpak

New User


Joined: 06 May 2005
Posts: 18

PostPosted: Tue Jun 07, 2005 11:43 am    Post subject: Re: how to compare between columns
Reply with quote

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
View user's profile Send private message
naanu

New User


Joined: 02 Jun 2005
Posts: 3

PostPosted: Tue Jun 07, 2005 12:37 pm    Post subject: Re: how to compare between columns
Reply with quote

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
View user's profile Send private message
Pushpak

New User


Joined: 06 May 2005
Posts: 18

PostPosted: Tue Jun 07, 2005 1:00 pm    Post subject:
Reply with quote

Hi,

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

Pushpak.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts compare 2 rows within the same file ram_vizag SYNCSORT 7 Wed Jun 14, 2017 12:34 am
No new posts member list compare jzhardy TSO/ISPF 6 Fri May 12, 2017 3:18 pm
No new posts unload data from table with lob columns farhad_evan DB2 1 Sat Apr 22, 2017 1:32 pm
No new posts Compare two files and subtract values ameetmund DFSORT/ICETOOL 7 Fri Mar 31, 2017 3:35 pm
No new posts fuzzy compare Martylin JCL & VSAM 9 Thu Mar 30, 2017 2:45 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us