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
- 18079 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
How many sessions of MAX is PE capable of handling at a particular time?
Describe the set operators in teradata.
Highlight the advantages of PPI(Partition Primary Index).
What are the various reporting tools in the market?
How would you load a very large file in teradata in general?
What are the primary characteristics of the Teradata.
What is a node in teradata? Explain
If a Node is busy what are the steps you can take to avoid ?
What is the particular designated level at which a LOCK is liable to be applied 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
Explain and compare pros and cons of snow flake schemas?
What is the difference between teradata and oracle?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
Highlight the differences between Primary Key and Primary Index.
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
