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

How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

4370


What is spool space?

1158


Highlight the advantages of PPI(Partition Primary Index).

1075


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

2013


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

1776


Explain some differences between mpp and smp?

1099


Explain the meaning of Amp?

1152


What are the available join types in teradata?

1066


What do you mean by caching in teradata?

1063


Explain the new features of teradata?

1042


How many codd's rules are satisfied by teradata database?

1112


What is difference between user and database in teradata?

1066


What are the functions involved in shared information architecture?

1073


How do you see a ddl for an existing table?

1018


Explain PDE.

1079