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
- 10528 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
How to assign new column names in a view?
How can you know if the row fetched from cursor is still valid in underlying table?
What is the rdl file?
What are clustered and non-clustered index?
How to create new databases with "create database" statements?
What are the advantages of using stored procedures?
Can you explain important index characteristics?
How to create a store procedure with encryption?
What is sql or structured query language?
What is tempdb database? : SQL Server Architecture
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
What are the types of stored procedures in an sql server?
What is a trigger in sql server?
Find first and last day of current month in sql server
How to drop an existing table with "drop table" statements in ms sql server?
