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
- 17913 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 is teradata? Also, list out some of the primary characteristics of teradata.
How is MLOAD Client System restarted after execution?
Can you connect multiload from ab initio?
What is the use of fallback?
Explain the term 'columns' related to relational database management system?
Define views in teradata with general syntax.
How would you load a very large file in teradata in general?
Explain vproc in teradata?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
how do you manage the production space. what are the proactive methods you can take ?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
Differentiate primary key and partition key?
What is the purpose of joins in teradata?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
What happens in a conflict? How do you handle that?
