SELECT STUDENTID, STUDENTNAME, CASE WHEN SUBJECT1>SUBJECT2 AND SUBJECT1

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

Question Posted / shanmukh

12 Answers
17613 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

Please Help Members By Posting Answers For Below Questions

What is basic teradata query language?

1036

What are the various indexes in teradata? How to use them?

958

Explain the term 'primary key' related to relational database management system?

983

In the Primary Index, what is the score of AMPs that are actively involved?

1002

What are the newly developed features of Teradata?

973

How do you determine the number of sessions?

1010

What are the functions involved in shared information architecture?

1019

What are normalization, first normal form, second normal form and third normal form?

999

Difference between star and snowflake schemas?

1056

Explain some differences between mpp and smp?

1037

What is multi insert?

986

What is meant by a Highest Cost Plan?

991

What is a clique?

1015

What are the commands to make a new table, change a table and remove a table in teradata?

1072

Explain the term 'columns' related to relational database management system?

994