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...

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?

Answer Posted / tdguy

use distinct or group by to avoid duplicates in teradata.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define views in teradata with general syntax.

982


how many modules are there in telecome domain?how to explain the architecture?

1962


How to Extract data from multiple legacy systems?

1040


What is the meaning of Caching in Teradata?

1080


If a Node is busy what are the steps you can take to avoid ?

2347


List out some of the primary characteristics of teradata.

925


What do you mean by fastexport in teradata?

940


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

979


Explain teradata architecture?

1031


What is the difference between global temporary tables and volatile temporary tables?

1082


How you will check the version of teradata?

1077


What happens in a conflict? How do you handle that?

987


What type of indexing mechanism do we need to use for a typical data warehouse?

1081


Describe the set operators in teradata.

952


How to run a query in teradata?

1007