You need to remove duplicate rows from a sybase table. How would you do that?



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

Post New Answer

More Sybase Interview Questions

How to restore sybase database in sap?

1 Answers  


How do I check if log truncation is blocked in sybase?

1 Answers  


Explain the structure of adaptive server enterprise?

1 Answers  


Explain procedure cache and data cache in sybase.

1 Answers  


Using large raw partitions with replication server on unix in sybase?

1 Answers  


What is sybase used for?

1 Answers  


How do I pipe the output of isql to a file in sybase?

1 Answers  


Differentiate between replication server and sql remote?

1 Answers  


What is the maximum nesting level of Stored Procedure and Triggers in Sybase?

2 Answers   L&T,


Are you doing the updates from within a cursor?

1 Answers  


How to remove row affected and dashes?

1 Answers  


How can I tell the datetime my server started?

1 Answers  


Categories