Write a sql query to delete duplicate records from a table called table1
No Answer is Posted For this Question
Be the First to Post Answer
Describe in brief system database.
How to insert data with null values?
Explain the steps to use transact-sql cursor?
Can I recover a damaged SQL Server 2008 database with the undamaged .mdb and .ldf files?
what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration
What are SQL Jobs, please mention the use of it and how to create them.
What is database mirroring?
What command is used to delete a table from the database in the sql server and how?
I have a table emp , Fields with empname,dnname,dno,salary. now I want copy distinct salary with all emp detail from emp into new table which is not already exist in database. how would I do this ?
sql server has its default date format in da form "yy-mm-dd" its possible to convert da current date format of sql server to desired format. Now my question is dat how to get da previous and comin days date in my desired format??
What is side by side migration in sql server?
Why functions are used 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)