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
- 25747 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 |
Explain what role entity and relationship play in an ER diagram.
What happens when converting big values to numeric data types?
What does null mean?
What is resource governor in sql server?
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
What’s the use of custom fields in report?
What is transaction server consistency?
What is excution Plan in sql server
1 Answers CarrizalSoft Technologies, TCS,
Why I am getting this error when dropping a database in ms sql server?
Distinguish between nested subquery and correlated subquery?
What do you mean by subquery?
What is dbcc? Give few examples.
-
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)
