Skip to main content

Union,Union all, Intersect and Minus

MINUS

SELECT * FROM TABLE_NAME
WHERE  CONDITION=:VALUE
MINUS
SELECT * FROM TABLE_NAME
WHERE  CONDITION=:VALUE;





INTERSECT




SELECT * FROM TABLE_NAME
WHERE  CONDITION=:VALUE
INTERSECT
SELECT * FROM TABLE_NAME
WHERE  CONDITION=:VALUE;









UNION




SELECT * FROM TABLE_NAME
WHERE  CONDITION=:VALUE
UNION
SELECT * FROM TABLE_NAME
WHERE  CONDITION=:VALUE;









UNION ALL




SELECT * FROM TABLE_NAME
WHERE  CONDITION=:VALUE
UNION ALL
SELECT * FROM TABLE_NAME
WHERE  CONDITION=:VALUE;











































Comments











Post a Comment




















Popular posts from this blog




















Split String which has space and replace spaces with "/"




























Sample String "ABCD123 ETS, NM"    UPDATE  TABLE_NAME SET  COLUMN_NAME = SUBSTR( 'ABCD123 ETS, NM' , 0 , 4 )   || REPLACE ((SUBSTR(( REPLACE ( 'ABCD123 ETS, NM' , ', ' , '/' )), 5 ,INSTR(( REPLACE ( 'ABCD123 ETS, NM' , ', ' , ',/' )), ',' , 1 ) - 4 )), ' ' , '/' )   || REPLACE (SUBSTR( 'ABCD123 ETS, NM' ,INSTR( 'ABCD123 ETS, NM' , ',' , 1 )                                                        + 2 ), 'NM' , 'NEW MEXICO' ) WHERE  CONDITIONS;  




















Post a Comment









Read more






























Extracting Data in a Database Using Python




























 Extracting data in a database using python.   Using Python to extract data in a MySQL table       first we need to pip install pymysql   Create table along with connection to the mysql server using python    import pymysql  connection=pymysql.connect(host='host',port=port,user='user',password='password',db='schema')  #creating cursor  cursor= connection.cursor()  #query for create Table  TABLES={}   TABLES['employees'] = (      "CREATE TABLE employees ("      "PersonID int,"      "LastName varchar(255),"      "FirstName varchar(255),"      "Address varchar(255),"      "City varchar(255)"   ")")   for name, ddl in TABLES.items():      cursor.execute(ddl)      connection.commit()      connection.close()         Insert Data into the MySQL Table using Python   import pymysql  # Data set to insert  insert_people=[("8","Perera","L.D","123",...




















1 comment









Read more