You need to remove duplicate rows from a sybase table. How would you do that?
Answer / Mehtab Alam
To remove duplicate rows from a Sybase table, you can use the DISTINCT keyword in your SELECT statement or use the DROP DUPLICATES clause in a CREATE TABLE AS SELECT statement.
| Is This Answer Correct ? | 0 Yes | 0 No |
How to restore sybase database in sap?
How do I check if log truncation is blocked in sybase?
Explain the structure of adaptive server enterprise?
Explain procedure cache and data cache in sybase.
Using large raw partitions with replication server on unix in sybase?
What is sybase used for?
How do I pipe the output of isql to a file in sybase?
Differentiate between replication server and sql remote?
What is the maximum nesting level of Stored Procedure and Triggers in Sybase?
Are you doing the updates from within a cursor?
How to remove row affected and dashes?
How can I tell the datetime my server started?
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)