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

In the Primary Index, what is the score of AMPs that are actively involved?

1053


What do you mean by fastexport in teradata?

980


Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?

1939


Explain the teradata primary index mechanics in detail with a diagram.

957


What is real time and near real time data warehousing?

1102


Differentiate database data and data warehouse data?

1092


What are normalization, first normal form, second normal form and third normal form?

1036


What is the function of parser component in teradata?

1065


What are the 5 phases in a multiload utility?

1019


Explain teradata utilities?

1019


How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1762


What are teradata utilities?

1094


What are the steps to create a data model?

1029


What is the particular designated level at which a LOCK is liable to be applied in Teradata?

1025


What is the opening step in basic teradata query script?

1024