We have moved to www.dataGenX.net, Keep Learning with us.

Tuesday, December 30, 2014

Delete Duplicate Rows in DB2 Database


Many times and Many places, this question is being asked :-) that How to delete the duplicate row from a table in different DBs. Here, we will see How to do this in DB2 DB.

Wednesday, December 10, 2014

Create table from another table in TeraData database

Same Queries for Teradata DBs -


===========================================================================
===========================================================================

Tuesday, December 09, 2014

Create table from another table in Oracle database


How to do the same in Oracle DB as we did in DB2 -Create table from another table in DB2 database
In Oracle, it is quite simple to create the duplicate tables with data :-)

Let's see How --

Monday, December 08, 2014

Create table from another table in DB2 database


We can create a table from another table definition but without data in DB2. We need write a another sql to insert the data into newly created table.

Let's see how to do this --