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


Please Help Members By Posting Answers For Below Questions

What are the available primary index types in teradata.

560


In Teradata, what is the significance of UPSERT command?

564


what is object level locking ? where do appear this type of locking ?

3083


What is a clique?

562


tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

350






What do you mean by caching in teradata?

584


What are the design features involved in teradata?

524


If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

614


Why is the case expression used in teradata?

564


What is teradata? What are some primary characteristics of teradata?

527


What are aggregate tables? How do you design them using teradata?

609


What is meant by a Clique?

557


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?

1593


What's the difference between timestamp (0) and timestamp (6)?

608


What are the steps to create a data model?

575