Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 72 - 2611_SmartGPT Pro V(5.0) C-8
P. 72

    For example, to find students older than 15 and show their StudentID, FirstName, and Age, use the
                      following SELECT command:

                      In SQL, you can retrieve data based on multiple conditions by using the AND and OR operators.
                      These operators allow you to combine more than one condition through the WHERE clause.

                      For example, to find the StudentID and FirstName where Age is 16 and FirstName is ‘Saanvi’, use
                      the following SELECT command:

                                                  What is the role of SQL operators?

                                UPDATING RECORDS IN A TABLE

                      To modify  existing  records in a table,  use  the UPDATE command.  The basic  syntax  for  the
                      UPDATE command is as follows:

                      UPDATE table_name SET Column = value WHERE condition;

                       70   Computer Science (V5.0)-VIII

| 67 68 69 70 71 72 73 74 75 76 77 |