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
- 17619 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
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
What is bteq script in teradata?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
What is oltp?
Difference between inner join and outer join?
how can we analyze the locks ?
Highlight all the modes that are present under Confidence Level.
What is the purpose of joins in teradata and what are the available join types?
how do you manage the production space. what are the proactive methods you can take ?
Explain the term 'primary key' related to relational database management system?
What are the steps involved in the process flow of the sql statement through channel attached system?
what are the day to day activities of teradata DBA ?
What is the opening step in basic teradata query script?
Describe primary index in teradata?
