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

one table have
input
no name
10 rao
20 siva
30 srinu
10 rao
i want to ouput like this way
no name
20 siva
30 srinu
10 rao
how it posible in only sql server query?not oracle?

Question Posted / guest

Answers were Sorted based on User's Feedback



one table have input no name 10 rao 20 siva 30 srinu 10 rao i want to ouput lik..

Answer / babu

Hi,

sel no,name from table group by no,name order by no,name;

Is This Answer Correct ?    6 Yes 3 No

one table have input no name 10 rao 20 siva 30 srinu 10 rao i want to ouput lik..

Answer / ankal

This problm solve only using Distinct or Group by
syntax:
1:sel distinct no,name from tablename;
2:sel no,name from tablename group by no,name;

Is This Answer Correct ?    3 Yes 1 No

one table have input no name 10 rao 20 siva 30 srinu 10 rao i want to ouput lik..

Answer / tdguy

use distinct or group by to avoid duplicates in teradata.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Teradata Interview Questions

what is the difference between bpo and call centre?

2 Answers   American Solutions,

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

0 Answers  

How do you define Teradata?

0 Answers  

tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

0 Answers  

What is the difference between fastload and multiload? Which one is faster?

0 Answers  

Is PK concept available in Teradata. If it is how can we create Primary Key for a table in TD

6 Answers   Wipro,

What are two examples of an OLTP environment?

4 Answers  

Give some points about Teradata Viewpoint ?

3 Answers   Teradata,

Why MultiLoad Utility supports only Non Unique Secondary Index(NUSI) in the Target Table ?

9 Answers   IBM,

When tpump is used instead of multiload?

0 Answers  

What are default access rights in teradata? What explicit right can be given to a user?

0 Answers  

What is the default join strategy in Teradata???

5 Answers   IBM,

For more Teradata Interview Questions Click Here
Categories