Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Teradata
  2. Suggest New Category

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

Question Posted / guest

Answers were Sorted based on User's Feedback



i have column like below studentid studentname sub1 sub2 sub3 1 aaa 40 70 ..

Answer / radhika

Sel studentid,studentname,greatest(sub1,sub2,sub3) from tablename;

Is This Answer Correct ?    0 Yes 0 No

i have column like below studentid studentname sub1 sub2 sub3 1 aaa 40 70 ..

Answer / 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

More Teradata Interview Questions

What is the default join strategy in Teradata???

5 Answers   IBM,

How do you design aggregate tables using teradata?

1 Answers  

Discuss the advantages of using partitioned primary index in a query?

0 Answers  

What is Join Index in TD and How it works?

6 Answers   BT, CSC, TCS,

Does any body has TERADATA Certification Dumps, if any body is having please let me know to summee4you@gmail.o, it is very Very URGENT to me

25 Answers   TCS,

What is the purpose of joins in teradata?

0 Answers  

What are the different methods ot loading a dimension table? A fact table etc?

0 Answers  

What is the function of parser component in teradata?

0 Answers  

Differentiate database data and data warehouse data?

0 Answers  

how do you handle ET and UV errors ?

2 Answers  

If RDBMS is halted what will you do ?

0 Answers   Teradata,

Comment whether bottleneck is an error or not.

0 Answers  

For more Teradata Interview Questions Click Here
Categories