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

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

0 Answers  

Did you write stored procedures in teradata?

0 Answers  

what is meant by Hot amp?

2 Answers   IBM, Satyam,

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

6 Answers   JPMorgan Chase,

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

0 Answers   HP,

What is upsert statement in teradata?

0 Answers  

can we join volatile table with general table an global temporary table with general table ?

4 Answers   IBM,

What's the difference between timestamp (0) and timestamp (6)?

0 Answers  

How to cast date "2015-03-03-012204-000000" to timestamp

1 Answers   Cognizant,

How do you Generate Sequence in Teradata?

3 Answers   TCS,

hi guys...i have good experiance in oracle ...now i want to learn teradata? how much of percentage my knowledge is used to understand the teradata? i mean.. if teradata also having sql queries or not?

1 Answers  

What is meant by a Channel Driver?

0 Answers  

For more Teradata Interview Questions Click Here
Categories