Interested to Buy Any Domain ? << Click Here >> for more details...
How to delete duplicate records from a table?(for suppose in
a table we have 1000 Records in that we have 200 duplicate
Records , so ,how to findout that duplicate Records , how to
delete those Records and arranged into sequence order? one
more thing that there is no primary key at all)
- 5 Answers
- 10905 Views
- Infosys, McAfee, I also Faced
- E-Mail Answers
Answer Posted / sirisha
with numbered as(select rowno = row_number() over(partition
by empid order by empid),empname from employee)delete from
numbered where rowno > 1
| Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
How to create an index on a view?
How to create a view using data from another view?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
What stored by the tempdb ? : sql server database administration
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
What is the difference between coalesce() & isnull()?
what is blocking? : Sql server database administration
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Can a database be shrunk with users active?
How to optimize stored procedures in sql server?
What is a fan-out query in SQL Azure?
What are the restrictions applicable while creating views? : SQL Server Architecture
How can you insert null values in a column while inserting the data?
what is a check constraint?
