Interested to Buy Any Domain ? << Click Here >> for more details...
in tabase table having a column in it empname field is
there which having 5 duplicate values is there i want
deleted all the duplicates i want showing only one name
only.
- 7 Answers
- 10299 Views
- I also Faced
- E-Mail Answers
Answer Posted / dinesh gupta
use distinct commond
distinct(ename) from table name
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Is it true that rules do not apply to data already existing in a database at the time the rule is created?
What is the stored procedure?
What is difference between equi join and natural join?
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
How and why use sql server?
What is the maximum row of a size?
how can you check the level of fragmentation on a table? : Sql server administration
how you can get the list of largest tables in a database? : Sql server administration
What is store procedure? How do they work? When do you use?
What is role playing dimension with two examples? : sql server analysis services, ssas
Explain mixed authentication mode of sql server?
How do I schedule a sql server profiler trace?
how many bits ip address consist of? : Sql server database administration
What are rest-style architecture's?
How do you delete duplicate rows in sql server?
