Interested to Buy Any Domain ? << Click Here >> for more details...
Is it possible to delete duplicate rows in a table without
using a temporary table ?
- 12 Answers
- 25217 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / saravanan
select * into #empnew from (select * from emp union select
* from emp) a
| Is This Answer Correct ? | 1 Yes | 6 No |
What is view in sql?
What is triggers and stored procedures?
What is compound operators?
Explain log shipping and mention its advantages.
Does a full backup include transaction log?
Explain difference between control flow and data flow?
Explain error handling in ssis?
write the query for taking database restore in sql?
How to get the definition of a user defined function back?
Is there any difference between primary key and unique with the not null condition?
How does normalization work?
What do you understand by integration services in sql server?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
