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
What are the available primary index types in teradata.
In Teradata, what is the significance of UPSERT command?
what is object level locking ? where do appear this type of locking ?
What is a clique?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
What do you mean by caching in teradata?
What are the design features involved in teradata?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
Why is the case expression used in teradata?
What is teradata? What are some primary characteristics of teradata?
What are aggregate tables? How do you design them using teradata?
What is meant by a Clique?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
What's the difference between timestamp (0) and timestamp (6)?
What are the steps to create a data model?