Page 318 - IT 402 v2.0 class 10
P. 318

OPERATORS                            DESCRIPTION                                   MP

                              Checks if value of ‘a’ is less than or equal to value of ‘b’. If
                  ‘<=’                                                                   a  b  is true.
                              yes, condition becomes true, else false.
                              Checks if value of ‘a’ is less than value of ‘b’. If yes, condition
                   ‘<’                                                                   a b  is true.
                              becomes true, else false..
                              Checks if value of ‘a’ is not less than value of ‘b’. If yes,
                   ‘!<’                                                                  a  b  is false.
                              condition becomes true, else false.
                              Checks if value of ‘a’ is greater than or equal to value of ‘b’.
                  ‘>=’                                                                   a  b  is false.
                              If yes, condition becomes true, else false.
                              Checks if value of ‘a’ is not greater than value of ‘b’. If yes,
                   ‘!>’                                                                  a  b  is true.
                              condition becomes true.


        S    ogical   erators
               OPERATORS                                        DESCRIPTION
                   ALL          It is used to compare a value to all values in another value set.

                   AND          It allows the existence of multiple conditions in SQL statement.
                   ANY          It compares the value in list according to the condition.
                BETWEEN         It is used to search for values within the set of values.
                   NOT          It reverses the meaning of any logical operator.
                    OR          It is used to combine multiple conditions in SQL statements.


               T  T

        Table is a collection of organised data in the form of rows and columns. It is used to represent the relations.

                               STUDENT_NAME            ADDRESS                PHONE
                              Sanjay Jain                 Pune             9800000000
                              Abhijit Kundu               Delhi            9100000000

        S    reate Ta le  ommand

        SQL Create Table statement is used to create a table in database. To create a table, assign a name to the table
        and then define columns and the data types of each column.

        S nta :
        CRE AT E  T AB L E  T AB L E _ NAM E
        (
            colu mn_ name1  d ata_ ty p e ( siz e) ,
            colu mn_ name2  d ata_ ty p e ( siz e) ,
            colu mn_ name3  d ata_ ty p e ( siz e) ,
            .....
            .....
            colu mn_ nameN d ata_ ty p e ( siz e)
        ) ;





         316       Touchpad Information Technology-X
   313   314   315   316   317   318   319   320   321   322   323