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
Answer Posted / navneet sharma
select distinct * from tablename
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
How does using a separate hard drive for several database objects improves performance right away?
What is sql server profiler trace data file?
What is difference between sql and sql server?
What are basics of policy management?
What is normalization and its types?
What are dml triggers and types of dml triggers?
What are the types of table?
Can we take the full database backup in log shipping?
What different steps will a sql server developer take to secure sql server?
how to determine the service pack currently installed on sql server? : Sql server database administration
How sql server executes a statement with nested subqueries?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
What is 'Join' and explain its various types.
On a windows server 2003 active – passive failover cluster, how do you find the node which is active?
What is transaction server consistency?