i have column like below studentid studentname sub1 sub2 sub3 1

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

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

Answers were Sorted based on User's Feedback

i have column like below studentid studentname sub1 sub2 sub3 1 aaa 40 70 ..

Answer / radhika

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

Is This Answer Correct ?

0 Yes

0 No

i have column like below studentid studentname sub1 sub2 sub3 1 aaa 40 70 ..

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

More Teradata Interview Questions

What is the difference between teradata and oracle?

0 Answers

What are the different methods ot loading a dimension table? A fact table etc?

0 Answers

I want to load 1000 rcds using. FL for every 100 records there is a check point.But script failed at 120 records, when we are restarting the script, it starts from last ckpt, but Target table contains populated data but FL doesnt support existing data in target table. How can we load data in FL?

4 Answers IBM,

what do you mean by INMOD Routines and OUTMODE Routines ?

3 Answers

write a query following data. 123.45 is input.write a query after decimal (ex:.45) load into database ?how it possible?

3 Answers IBM,

can we have an unconnected lkp to lookup a DB2 record against a Teradata record?

3 Answers

any one pls tell me what are the table names in banking project?

2 Answers

What are the various reporting tools in the market?

0 Answers

What is the use of having index on table?