Interested to Buy Any Domain ? << Click Here >> for more details...
How To delete duplicate record from a particular table?
- 12 Answers
- 24520 Views
- eXensys, Foxfire, I also Faced
- E-Mail Answers
Answer Posted / deepa
For Example
sno names
1 arun
2 arun
3 arun
6 arun
7 bala
11 bala
12 guna
9 guna
14 guna
10 raj
13 raj
Table Name T1
Fields Names Sno,Names
Delete From t1 where sno not in
(select min(sno) from t1 group by names)
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
What are the different kinds of ssrs reports?
What are indexers?
What is raiseerror? What is raiseerror?
How to write character string constants or literals in ms sql server?
Is natural join and equi join same?
What is checkpoint process in the sql server?
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?
How we can refresh the view?
What is sql server management studio? : sql server management studio
What are the different subsets of sql?
What is normalization according to you and explain its different levels?
Explain system scalar functions?
What is the difference between varchar and varchar(max) datatypes?
How to get a list of columns in a view using the "sp_help" stored procedure?
How to get a list of columns using the "sys.columns" view in ms sql server?
