GeekInterview.com
Series: Subject: Topic:
Question: 4 of 92

Remove one duplicate column value from multiple

How to remove only one column values from the duplication of values in that column without using any other column references in that table?
Asked by: chiru099 | Member Since Jul-2012 | Asked on: Sep 13th, 2012

View all questions by chiru099   View all answers by chiru099

Showing Answers 1 - 1 of 1 Answers
dhanraj varshney

Answered On : Jan 5th, 2013

Two methods..
Use unique key
Run query such way-insert ignore into table.

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Answered Questions

Related Open Questions

User Panel

Register
Login
Lost Password
Get Activation Code

Categories

Btrieve

Clipper

Database Admin

Firebird

Informix

Microsoft Access

MYSQL

PostgreSQL

Progress

SAP DB

SQL

SQL Server

Stored Procedures

Sybase

Teradata

Unify

Interview Coaching

Aptitude Test Preparation Tips

What is the role of a mechanical engineer in the Software Industry?

What will you do when you are not able to get your message across to your audience?

How do you approach a problem?

Do you find yourself busy most of the time? Why?

How do you handle workplace problems?

Tell me three things about you, which are not found in your resume

What do you do when someone criticizes you?

Do you have any questions that you want to ask?

What are the career opportunities available for MCA Graduates?

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Question Categories

Btrieve Interview Questions

Clipper Interview Questions

Database Admin Interview Questions

Firebird Interview Questions

Informix Interview Questions

Microsoft Access Interview Questions

MYSQL Interview Questions

PostgreSQL Interview Questions

Progress Interview Questions

SAP DB Interview Questions

SQL Interview Questions

SQL Server Interview Questions

Stored Procedures Interview Questions

Sybase Interview Questions

Teradata Interview Questions

Unify Interview Questions

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.

Subscribe