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
18066 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

Can we collect statistics on table level?

1037

What is the difference between fastload and multiload?

1386

Why managing the data is important?

1019

What is meant by Teradata Gateway?

1064

What is the purpose of joins in teradata?

1191

In Teradata, what is the significance of UPSERT command?

1234

What is a sparse index?

1088

What does sleep function does in fast load?

1144

How many sessions of MAX is PE capable of handling at a particular time?

1083

What are the enhanced features in teradata v2r5 and v2r6?

1138

What is the difference between fastload and multiload? Which one is faster?

1227

Syntax for case when statement?

1069

What is database exceptions in teradata?

957

why use references rather than pointers in the public api, particularly for arguments which are modified?

1011

How to view every column and the columns contained in indexes in teradata?

1056