Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to remove duplicate records without using primary key column?
- 2 Answers
- 9269 Views
- ABCO, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
What is the security principal at the server level that represents your session?
Differentiate between a having clause and a where clause.
What is the name of the Database which IBM mainframe uses?
Can you edit the .rdl code associated with a linked report?
List some advantages and disadvantages of stored procedure?
What is bcp? When does it used?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
What is the exact numeric data type in sql?
how you can list all the tables in a database?
How many replicas are maintained for each sql azure db?
Explain nested stored procedure. Syntax and an example for create nested stored procedure?
What are the rendering extensions of ssrs?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
What is the difference between a function and a stored procedure?
