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
- 18385 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
What do you mean by teradata intelliflex?
What are aggregate tables? How do you design them using teradata?
What are the steps involved after the disk manager passes the request?
What's the difference between timestamp (0) and timestamp (6)?
Describe the between keyword in teradata?
What are the various indexes in teradata? How to use them? Why are they preferred?
What are the functions of a teradata dba?
List out teradata data types?
What are the different table types that are supported by teradata?
What does sleep function does in fast load?
Explain teradata utilities?
Explain the term 'row' related to relational database management system?
Why are oltp database designs not generally a good idea for a data warehouse?
Why is the case expression used in teradata?
How will you solve the problem that occurs during update?
