DAY _ 3 : PostgresSQL Query Session.

💬Hey, Hello Friend's, Have A Nice Day 

 👊 Now, We Have to Move to Our Next Session.

# Adding Data Into a Table.

✌ SYNTAX :

                            INSERT  INTO Table_Name(Column_name1,  Column_name2, .. .. )

                            VALUES(Data1, Data2, .. .. .. );

                                         OR 

                           INSERT INTO Table_Name 

                           VALUES( Data1, Data2);


👉 READ OPeration.

    * Read Operation refers to retrieving Data from a Database table.

    * Feteching data from one or more table.

✌ SYNTAX :

                       SELECT Column_Name1, Column_Name2, Column_Name3

                       FROM Table_Name;

                      OR

                       SELECT  *

                       FROM Table_Name;


 (1.)   Here We Have to Select Entire Table.

           SELECT * FROM Person;


(2.)  Here We Have to Select Only First_Name,  Last_Name

       SELECT First_Name

       , Last_Name

       FROM Person;

(3.)  Here We Have to Select Only Last_Name And Age

       SELECT Last_Name

      ,  Age

     FROM Person;


Comments