i have column like below
studentid studentname sub1 sub2 sub3
1 aaa 40 70 90
2 bbb 60 80 50
i want to execute every student highest mark in which subject
my o/p like below
studentid studentname sub3 sub2
1 aaa 90
2 bbb 80
Answer Posted / yuvaevergreen
typo error in the above answer, its not "query to fetch the students topped in all the three"...its just students topped in each subjects....its typo
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How do you set the session mode parameters in bteq?
What are the multiload utility limitations?
Why teradata is used?
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
Explain amp in teradata?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
What are the string manipulation operators and functions associated with teradata?
Explain some differences between mpp and smp?
What tools would you use for that?
What is the use of having index on table?
How to Extract data from multiple legacy systems?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
How is MLOAD Teradata Server restarted after execution?
How many codd's rules are satisfied by teradata database?
What are the components used in smp and massively parallel processing (mpp) machines?