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
- 18073 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / shanmukh
SELECT STUDENTID, STUDENTNAME,
CASE WHEN SUBJECT1>SUBJECT2 AND SUBJECT1>SUBJECT3
THEN SUBJECT1 END AS SUBJECT1,
CASE WHEN SUBJECT2>SUBJECT1 AND SUBJECT2>SUBJECT3
THEN SUBJECT2 END AS SUBJECT2,
CASE WHEN SUBJECT3>SUBJECT1 AND SUBJECT3>SUBJECT2
THEN SUBJECT3 END AS SUBJECT3
FROM STUD1;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the use of virtual processor connectivity in teradata?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
What are the steps to create a data model?
Explain the term 'row' related to relational database management system?
Explain and compare pros and cons of snow flake schemas?
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?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
What are the different functions included in the server software?
What are the different functions performed in development phase?
Explain fastload in teradata?
Highlight all the modes that are present under Confidence Level.
What is teradata? What are some primary characteristics of teradata?
What are differences between teradata and ansi session modes in teradata?
What are teradata utilities?
Can we collect statistics on table level?
