Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 22630 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
Can we deploy SSRS reports on our personal website?
What is difference between views and stored procedures?
What are ddl (data definition language) statements for tables in ms sql server?
What is the minimum recommended amount of ram for sql server 2012 enterprise?
What are the different editions available in sql server 2000?
How to execute stored procedure in select statement sql server?
How to list all columns in a table using odbc_columns()?
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 do you know about normalization and de- normalization?
What is de-normalization and what are some of the examples of it?
What are the different types of indexes?
what is a self join? : Sql server database administration
Explain the different types of backups available in sql server? : sql server database administration
What are scalar functions in sql?
What are synonyms?
