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

Can any one please provide me practical example of How to do the performance tuning in Query??

5 Answers   Amdocs,

Please tell me a query to find the Primary key,Foreign key,primary Index,PPI for the Database?

5 Answers  

How can bottlenecks be identified?

0 Answers  

Explain teradata architecture in detail with a diagram.

0 Answers  

Explain teradata utilities. What is multiload, fast load, tpump?

0 Answers  

Give a justifiable reason why Multi-load supports NUSI instead of USI.

0 Answers  

Highlight the advantages of PPI(Partition Primary Index).

0 Answers  

Why is the case expression used in teradata?

0 Answers  

What are the various etl tools in the market?

0 Answers  

How to eliminate product joins in a teradata sql query?

0 Answers  

Explain the term 'foreign key' related to relational database management system?

0 Answers  

What is Join Index in TD and How it works?

6 Answers   BT, CSC, TCS,

For more Teradata Interview Questions Click Here
Categories