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
- 17910 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 |
How a Referential integrity is handled in Teradata?
Comment whether bottleneck is an error or not.
What are the components used in smp and massively parallel processing (mpp) machines?
what are the uses of fact table and dimension table in banking project?
Aborted in Phase 2 data acquistion completed in fastload?
I want to load 1000 rcds using. FL for every 100 records there is a check point.But script failed at 120 records, when we are restarting the script, it starts from last ckpt, but Target table contains populated data but FL doesnt support existing data in target table. How can we load data in FL?
Hi Friends I have a sql question, We have the source data as below. 101 address1, address2, address3 and the output shoulb like below 101 address1 101 address2 101 address3 Required a SQL query for this output. Please let me know if you have any sql query for this. Thanks in advance. Hari M
What is bteq utility in teradata?
Steps to create a data model?
Explain the new features of teradata?
How do you create tables? Exact syntax, and create profiles, users in teradata?
Write a program to show the parser component used in teradata?
Teradata 
