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
18399 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 to run a query in teradata?

1145

Give the sizes of SMALLINT, BYTEINT and INTEGER.

1212

What is primary index and secondary index?

1066

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3420

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

1212

what are the day to day activities of teradata DBA ?

5860

How to identify ppi columns?

1246

What are some commonly used bteq scripts?

1058

What are the different design perspectives used in teradata?

1035

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1825

Explain and compare pros and cons of start schemas?

1149

Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

1128

What is spool space? Why do you get spool space errors? How do trouble-shoot them?

1041

What are the newly developed features of Teradata?

1081

What are the uses of client software involved in teradata?

1036