Skip to main content

SQL Set Operators

SQL Set Operators   Traditional Set Operators: Union Compatibility:     Requirement for the traditional set operators.    Strong requirement.                         - Same number of columns.                         - Each corresponding column is compatible.                         - Positional correspondence.     Apply to similar tables by removing columns first. SQL UNION Example:           Example 1: Retrieve basic data about all university people.                     SELECT FacNo AS PerNo, FacFirstName                                      ...
Post a Comment

Major SQL Statements

Major SQL Statements

Statement                                    Statement Type

CREATE TABLE                                                 Definitional, Control

CREATE VIEW                                                   Definitional

CREATE TYPE                                                   Definitional

SELECT                                                               Manipulation

INSERT, UPDATE, DELETE                            Manipulation

COMMIT, ROLLBACK                                    Manipulation

CREATE TRIGGER                                          Control, Manipulation

GRANT, REVOKE                                             Control



Our Official Website : Web Conquerors (https://www.webconquerors.com/) 

Want to get digital services? Contact US

Want to know about our services? Our Services



Comments

Post a Comment

Popular posts from this blog

SQL Set Operators

SQL Set Operators   Traditional Set Operators: Union Compatibility:     Requirement for the traditional set operators.    Strong requirement.                         - Same number of columns.                         - Each corresponding column is compatible.                         - Positional correspondence.     Apply to similar tables by removing columns first. SQL UNION Example:           Example 1: Retrieve basic data about all university people.                     SELECT FacNo AS PerNo, FacFirstName                                      ...
Post a Comment
Read more

Differences Between Algorithm and Pseudocode

  "Differences Between Algorithm and Pseudocode" Algorithm Pseudocode 1.       Systematic logical approach which is a well-defined, step-by-step procedure that allows a computer to solve a problem. It is a simpler version of a programming code in plain English which uses short phrases to write code for a program before it is implemented in a specific programming language. 2.       Algorithms can be expressed using natural language, flowcharts, etc. There are several formats which are used to write pseudo-codes and most of them take down the structures from languages such as C, Lisp, FORTRAN, etc. 3.      Procedure of algorithm is like this Start from the leftmost element of arr[] and one by one compare x with each element of arr[]. If x matches with an element, return the index. If x doesn’t match with an...
Post a Comment
Read more

CREATE TABLE Syntax

CREATE TABLE Syntax CREATE TABLE <table-name> ( <column-list> [<constraint-list>] ). Column list with data types and optional and inline constraints. Optional external constraint list  CONSTRAINT [ ConstraintName ] <Constraint-Spec>            Primary key            Foreign key            Unique            Check CREATE TABLE Statement Example CREATE TABLE Student            ( StdNo CHAR(11),            StdFirstName VARCHAR(50),            StdLastName VARCHAR(50),            StdCity VARCHAR(50),            StdState CHAR(2),            StdZip CHAR(10),            ...
Post a Comment
Read more