Try below : sel studentid,studentname, greatest(sub1,sub2,sub3) max

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 / sonal

12 Answers
17903 Views
CTS, I also Faced
E-Mail Answers

Answer Posted / sonal

Try below :

sel studentid,studentname, greatest(sub1,sub2,sub3) max_masks
from student

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Differentiate database data and data warehouse data?

1092

What is the syntax for case when statement?

1111

What is TPD?

1353

Explain BYNET.

983

What is a dimension table?

1034

how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u

1711

What is upsert statement in teradata?

1111

What are the updated features of teradata?

1026

What is the difference between global temporary tables and volatile temporary tables?

1151

Explain the teradata primary index mechanics in detail with a diagram.

955

There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?

1096

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2154

Highlight the limitations of TPUMP Utility.

1095

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

1043

How teradata makes sure that there are no duplicate rows being inserted when its a set table?

969