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
- 10293 Views
- I also Faced
- E-Mail Answers
Answer Posted / ambarish
we can use cursor.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between a function and a stored procedure?
What is bit data type? What's the information that can be stored inside a bit column?
What is stretch database in sql server?
What are logical/boolean operations in ms sql server?
Why are views required in the sql server or in any other database?
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
How to delete duplicate rows from table except one?
Will count(column) include columns with null values in its count?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
How to loop through result set objects using odbc_fetch_row()?
Can you explain powershell included in sql server 2008?
What new changes are being made in SQL Server?
Explain four layers of abstraction microsoft architectured?
what is a transaction? : Sql server database administration
As per your opinion what are the five top responsibilities of a dba? : sql server database administration
