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
- 17925 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / hariharan
sel
studentid,
studentname,
case
when subject1>subject2 and subject1>subject3
then subject1
when subject2>subject1 and subject2>subject3
then subject2
when subject3>subject1 and subject3>subject2
then subject3
end as high_score,
case
when high_score = subject1
then 'subject1'
when high_score = subject2
then 'subject2'
when high_score = subject3
then 'subject3'
end as subject_name
from stud1
order by 1,2
;
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is meant by a Clique?
During the Display time, how is the sequence generated by Teradata?
What are the design features involved in teradata?
What is partitioned primary index (ppi)?
What are the scenarios in which full table scans occurs?
Is multi insert ansi standard?
Explain and compare pros and cons of start schemas?
What is multi insert?
What is stored procedure in teradata?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
What are differences between teradata and ansi session modes in teradata?
Can we collect statistics on table level?
What is the purpose of joins in teradata?
Explain the most common data types used in teradata?
What is upsert statement in teradata?
