write a query to remove duplicate records without using primary key column?
Answers were Sorted based on User's Feedback
Answer / 312
|Is This Answer Correct ?||3 Yes||3 No|
Answer / mathanrathinam
delete tmp from(select col1,col2,row_number over(partition by col1,col2 order by col1,col2) rownum from tablename) tmp
where rownum >1
|Is This Answer Correct ?||7 Yes||8 No|
what is normalization? Explain different levels of normalization? : Sql server database administration
when we use function instead of procedure? plz tell me the situation with ex?
How to create a new login name in ms sql server?
Which command is used for user defined error messages?
Which system table contains information on constraints on all the tables created?
What does it mean if @@cursor_row returns a negative number?
How to make remote connection in database?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
What is enhanced database mirroring in sql server 2008?
How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?
What happens if null values are involved in string operations?
What are the disadvantages of using querystrings to send data from one page to another?