Delete duplicate rows from a table without primary key by
using a single query
Table Employee
empname salary
A 200
B 300
A 200
C 400
D 500
D 500
Output should be
A 200
B 300
C 400
D 500
- 14 Answers
- 18515 Views
- I also Faced
- E-Mail Answers
Answer Posted / navneet sharma
select distinct * from tablename
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
What stored by the model?
How many types of attribute relationships are there? : sql server analysis services, ssas
What is Command line parameters in PLSQL.?
Do you know what is xpath?
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
how many triggers you can have on a table? : Sql server database administration
What is pivot and unpivot?
Explain sql server service broker?
Define Unique Key?
How adventureworkslt tables are related?
What is a view in sql?
What are the differences between char and varchar in ms sql server?
Explain temporary table vs table variable by using cursor alternative?
What does asynchronous call backs means?
