Is drop table faster than truncate?
No Answer is Posted For this Question
Be the First to Post Answer
explain the difference between delete , truncate and drop commands? : Sql dba
i need department wise top 2 employees salary.which logic i will use
How do I trace sql profiler?
What is the starting oracle error number? What is meant by forward declaration in functions?
A table has 150 records. How do you retrieve 100th row to 120th row from that table ?
Is sql a microsoft product?
Difference between inline query and stored procedure?
How do I start pl sql?
What are the differences between in and exists clause?
Explain the difference between drop and truncate commands in sql?
Does oracle use sql?
Source is Sales Table: Sno Prod Sales Sales_Amount 1 A 10 2000 2 A 20 1000 3 C 10 3000 4 D 30 4000 5 A 20 1000 Target : Sales_Count T_Sales_Amt Sales_Count(A) T_Sales_Amt(A) 90 11000 50 4000 In single query, pls tell me.
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)