Sel studentid,studentname,greatest(sub1,sub2,sub3) from tablename;

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

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

Answer Posted / radhika

Sel studentid,studentname,greatest(sub1,sub2,sub3) from tablename;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How can you track login parameters of users in teradata?

1176

What are the available primary index types in teradata.

1019

My table got locked during mload due to a failed job. What do I do to perform other operations on it?

1086

What does Amp contain and what are all the operations that it performs?

992

If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.

2152

How many codd's rules are satisfied by teradata database?

1096

If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

1138

Explain amp in teradata?

1060

Explain teradata architecture in detail with a diagram.

1098

How to select first n records in teradata?

1083

What is the use of virtual processor connectivity in teradata?

987

Describe primary index in teradata. And what are the available primary index types?

987

What are the advantages of teradata?

995

What is TPD?

1358

In Teradata, how do we Generate Sequence?

1029