Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 18094 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / radhika
Sel studentid,studentname,greatest(sub1,sub2,sub3) from tablename;
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sonal
Try below :
sel studentid,studentname, greatest(sub1,sub2,sub3) max_masks
from student
| Is This Answer Correct ? | 0 Yes | 0 No |
Difference between stored procedure and macro?
Can we collect statistics on multiple columns?
teradata support to automatically increase the character length or not?
Please tell me a query to find the Primary key,Foreign key,primary Index,PPI for the Database?
What are the components used in smp and massively parallel processing (mpp) machines?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
How many tables can you join in v2r5?
What are differences between teradata and ansi session modes in teradata?
What are the steps involved after the disk manager passes the request?
What is teradata? Also, list out some of the primary characteristics of teradata.
What is the use of having index on table?
What is Join Index in TD and How it works?
Teradata 
