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 a scheduled job or what is a scheduled task?
What are four major operators that can be used to combine conditions on a where clause?
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
What is CTE in SQL
how many clustered indexes can be created on a table? : Sql server database administration
How to list all user defined functions in the current database?
Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?
Explain the difference between cross join and full outer join?
What have included columns when we talk about sql server indexing?
What does normalization do to data?
How to check if stored procedure is running in sql server?
What are different types of join?
Explain the commands in sql server?
What do you mean by an execution plan? Why is it used?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?