Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 12 Answers
- 18074 Views
- CTS, I also Faced
- E-Mail Answers
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
Which is more efficient group by or distinct to find duplicates?
In Teradata, what is the significance of UPSERT command?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
What do high confidence, low confidence and no confidence mean in explain plan?
Explain Teradata performance tuning and optimization?
What are the components provided on node?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
What is the multi-insert?
In BTEQ, how are the session-mode parameters being set?
What are the functions of a Parser?
What is the primary index in teradata?
List out teradata data types?
What tools would you use for that?
Comment whether bottleneck is an error or not.
What are the scenarios in which full table scans occurs?
