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
- 12 Answers
- 15066 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
What are the different functions performed in development phase?
What is difference between user and database in teradata?
What are differences between teradata and ansi session modes in teradata?
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
How to select first n records in teradata?
how can we analyze the locks ?
Difference between multiload and tpump?
What do you mean by ttu in teradata?
What are the functions of a Parser?
What are the multiload utility limitations?
What is a three-tier data warehouse?
What do you mean by teradata intellicloud?
What is the difference between global temporary tables and volatile temporary tables?
Can we collect statistics on table level?
What are the newly developed features of Teradata?
