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

How to delete duplicates records in teradata without any
tables....?
with only one single query,,,?

Answer Posted / suganya

SELECT DISTINCT column_name(s)
FROM table_name

Is This Answer Correct ?    9 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

When usin qtp iam able to get the data from the database only in a single row that is if i have 2 columns in database,when using database output value , all the values in Database are transfered to a single row in QTP datatable. I want the values to appear as it is from the database , can anyone suggest some ideas?

1955


What are the phases of a formal review?

1072


What are the valuable steps to resolve issues while testing?

1402


Describe to the basic elements you put in a defect report?

1046


What is RC update and BRIO?

2920


Mention what bottom-up testing is?

1014


Explain defect?

1059


What is the bottom-up approach?

1132


What can be thought of as being based on the project plan, but with greater amounts of detail?

1071


hey, i recently attended 2 interviews and they asked whether I used qamonitor of softsmith. any help on what it does?

2144


What is variable trace?

1060


explain what test tools you will need for client server testing

3136


Explain exit criteria?

1050


Which types are testing are important for web testing?

1099


In MSBI also we need to write test cases please tell me because iam new to msbi

3461