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
- 10273 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
what are triggers? : Sql server database administration
What is an example of a primary key?
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
How do I get Report Builder to generate a parameter that can be set by users viewing the report?
What are window functions in sql server?
what is datawarehouse?
How to return the top 5 rows from a select query in ms sql server?
Will count(column) include columns with null values in its count?
What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration
What is the use of stored procedure?
Explain index in sql server?
what are different types of backups available in sql server? : Sql server database administration
If you want to send some data from access database to sql server database. What are different component of ssis will you use?
How do I run a trace in sql server?
What is rolap and its advantage? : sql server analysis services, ssas
