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

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