62 Views
Set Operations Set operations is used to merge query results by combining two or more queries into a particular single result.  SQL support three set operators which have the proper pattern.  <query 1> <set operators> <query 2> Union  The UNION command is ...
Anamika Gupta
Aug 14, 2018
136 Views
Rules for SQL commands 1. SQL  commands can be written on multiple line. 2. Clauses are generally used to separate lines to build accuracy through it is not necessary. 3. Tabulation (Index) can be used. 4. Command words cannot divide over the lines. 5. SQL ...
Anamika Gupta
Aug 09, 2018
75 Views
There are four types of SQL (structure query language) operator which is used to operate with all the data types. In the SQL if the attributes or data are used in the list they must be embedded in a single quote ( ' ' ). Operator Description BETWEEN....AND.....  It ...
Anamika Gupta
Aug 07, 2018
33 Views
What is SQL? SQL is a structure Query language which is used to manage relational database and perform various operations .It is a standardized programming language working on a  various queries such as INSERT,SEARCH, UPDATE, DELETE  database record. It is pronounced as ...
Anamika Gupta
May 24, 2018
618 Views
PostgreSQL is the open source relation database system. PostgreSQL has some advance features of database like  User-defined types Table inheritance Sophisticated locking mechanism Foreign key referential integrity Views, rules,subquery Nested transactions (savepoints) Multi-version ...
Sheetal Kumar
Feb 13, 2018
Page 1 of 1 Pages       Total Records 5
  • First
  • Prev
  • 1
  • Next
  • Last