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
- 15013 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 |
what is the structure of UV table in MLOAD?
What is logical data model?
How can we build data marts from FSLDM. is there any standard approach for this?Is FSLDM supports place ?
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
What are the various reporting tools in the market?
What is database exceptions in teradata?
In which scenarios we use Volatile tables and Global temporary Tables in Real time? Please give me one real time scenario???I know wat is its use??
Explain teradata vs. Redshift?
Highlight the advantages of PPI(Partition Primary Index).
What are the string manipulation operators and functions associated with teradata?
What is a sparse index?
1. generally how many node system will be used by the client. 2. while running mload if the job is aborted/failed at any phase what we have to look after to run the job successfully? 3.i wanted to know how to write the fastload script for table creation as well as table loading in a single script?
Teradata 
