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 are the difference between data mart and data warehouse? : sql server analysis services, ssas
What is a trigger? Why we need it?
What are the main sources of data?
How do you size a resultset?
How to apply filtering criteria at group level with the having clause in ms sql server?
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
Differentiate between sql temp table vs table variable?
Explain about nested stored procedure?
How to assign new column names in a view?
Explain the properties of subqueries in sql server?
How to delete duplicate rows from table except one?
What is the difference between a clustered index and a non-clustered index?
What are different types of replication in sql server?
Distinguish between nested subquery and correlated subquery?
What is Replication?