Answer Posted / monty
i have other solution if you have table employee with
duplicate rows. You can create other table that doesn't
have duplicate rows
select distinct * into newtable from employee
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is the difference between dropping a database and taking a database offline?
What is sub-query in sql server?
How can I know what locks are running on which resource?
Will count(column) include columns with null values in its count?
Explain nested join?
What is a livelock?
What is trace flag in sql server?
Show Practically Sql Server Views are updatable?
Mention the command used to rename the database.
Explain what is lock escalation?
What is @@error in sql?
What are the encryption mechanisms in sql server?
What is the data tier application?
What are the operating modes in which database mirroring runs?
Do you know what is sql service broker?