How to remove duplicate rows from table except one?
No Answer is Posted For this Question
Be the First to Post Answer
What is standby servers? Explain types of standby servers.
What is the default server name for sql server?
employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.
What is a view?
What is scalar user-defined function?
What is logon trigger?
what is the main difference between constraints(like primary key etc..)& joins?
How secure is sql server database?
You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
can any one post me, how to remove rows in the below table ENO ENAME EDEPT ELOC 3368 BPS BI Adayar 3371 RAN BI valachari 3369 SRI BI valachari 3372 jay BI Chn - - - - - - - -
Do you know what guidelines should be followed to help minimize deadlocks?
How to download and install sql server 2005 books online?
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)