Is drop table faster than truncate?
No Answer is Posted For this Question
Be the First to Post Answer
what are date and time data types in mysql? : Sql dba
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
Can we rollback truncate?
Can i possible to see Table Details ? Ex : Table Name Date Time User Emp May/18/2010 12:59pm Scott
What has stored procedures in sql?
Is subquery faster than join?
What is compiled query?
What is nosql db?
What is offset in sql query?
What is pl/sql table? Why it is used?
What is a call statement? Explain with an example.
one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows only how should u write query?
Oracle (3253)
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)