-
Given a table which contains some rows with duplicate keys, how would you remove the duplicates?
krishna kanth
- Apr 14th, 2011
Set rowcount 1delete from mytable where (select count(*) from Mytable group by col1 having count(*)>1)>1while(@@rowcount0) delete from mytable where (select count(*) from Mytable group by col1 having count(*)>1)>1set rowcount 0go
gcvpgeek
- Mar 3rd, 2009
We can do remove the duplicate records using the below single queryDelete from table1 where rowid not in (select max(rowid) from table1 group by dup_col)
-
How to get the list of tables in Sybase?
Read Best Answer
Editorial / Best Answer
rlbafna- Member Since Mar-2008 | Mar 12th, 2008
sp_help - lists all objects (including tables and views)
List if Views : select name from sysobjects where type = "V"
rlbafna
- Mar 12th, 2008
Sp_help - lists all objects (including tables and views)
List if Views : select name from sysobjects where type = "V"keerthv
- Apr 21st, 2007
Select name from sysobjects where type="U"This gives the list of user defined tables in the current database.
-
Secondary Truncation Point
What is Secondary Truncation Point?
luisgranados
- May 20th, 2011
Is a mark in the primary db log up to which the replication agent has processed transactions.
-
How to clear the logsegment when the Secondary truncation point is on ?
luisgranados
- May 20th, 2011
I suppose you want to do that because you refresh the database to a development/QA environment and you no longer need the replication to be working.So you just need to disable the secondary truncation...
dhampack
- Nov 24th, 2008
There are only two options to clear the log1) Kill the tran which is filling up the log2) Extend the transaction log to complete the transaction.don't use 'dump with truncate_only' if you ...
-
Views 'with check' Option
What is the use of 'with check' option in views?
Tejas More
- Jul 7th, 2011
The with check option flag prevents insertion or updating of rows that will not meet the view criteria. e.g.: create view cal_publishers_chk as ...
dhampack
- Nov 24th, 2008
When you create a view using the with check option clause, each insert and update through the view, is validated against the views selection criteria. If the rows inserted or updated are out of cri...
-
Add Not Null Column in a Table
How we can add a NotNull Column in a table by using alter command (without using default command)?
Tejas More
- Jul 7th, 2011
You can add a NOT NULL column to a table. This means that a constant expression, and not a null value, is placed in the column when the column is added. This also ensures that, for all existing rows, ...
UncaAlby
- Oct 20th, 2008
First add the column as NULL. Then populate the column with non-null data. Then modify the column to NOT NULL. You may need to set dboption "select into" to True.
-
Sybase Prefetch
What is the significance of the keyword 'prefetch' in SQL queries?
Tejas More
- Jul 7th, 2011
prefetch improves performance by anticipating the pages required for certain well-defined classes of database activities whose access patterns are predictable. The I/O requests for these pages are iss...
-
What is Sybase SQL Server?
neo.sql
- Sep 10th, 2011
Sybase SQL Server is the RDBMS developed by Sybase Inc (now an SAP company) which is now called as Sybase Adaptive Server Enterprise is the enterprise version and a flagship product of Sybase. Another...
luisgranados
- May 20th, 2011
Is the original name for the product we know today as Adaptive Server Enterprise.Sybase SQL Server name was changed since version 11.5 because they wanted to differentiate the product from Microsoft.
-
Sybase Stored Procedure and Triggers
What is the maximum nesting level of Stored Procedure and Triggers in Sybase?
neo.sql
- Sep 10th, 2011
The default option for maximum nesting level is 16 however this is a server configurable value and can be lesser than this also. To check the current maximum nesting level for stored procedures and tr...
-
Sybase ASE server Display the number value in Words
I need to convert a "check amount" to a "written out amount in english", for check printing.
Ex) $ 582.71 ---> Five hundred eighty two and 71 cents
-
Database BackUp
How will you take database backup when there is no space in file system?
ericpro
- Nov 21st, 2014
You can also try using remote backup so you can dump to another server with available space. of course you have to configure the interfaces between the servers to allow this.
-
Avoid Data Changes
How to avoid Data changes while retrieving data?
-
-
Sybase Interview Questions
Read Best Answer
Ans