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
- 25681 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 |
Tell me about Triggers?
What is a database in ms sql server?
How to override dml statements with triggers?
Where are full-text indexes stored?
How many types of Cursor in SQL SERVER?
Explain the dirty pages?
how many bits ip address consist of? : Sql server database administration
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
Define DML and DCL statements?
What structure can you implement for the database to speed up table reads?
-
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)
