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
- 9193 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
Write a program using SQL queries to find a unique entry in a table.
What are the different types of subquery?
What is sql server schema compare? How we can compare two database schemas?
What is sql service broker?
If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio
What is the difference between grant and with grant while giving permissions to the user?
What does ss stand for sexually?
what exactly sql injuction.how to overcome.....
What is index, cluster index and nonclustered index?
How to create an multi-statement table-valued function?
Can you please explain the difference between function and stored procedure?
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
What do you understand by physical_only option in dbcc checkdb?
What is the use of commit?
Can sql servers link to other servers like oracle?
