Question

A database table with name "PEOPLE" contains the fields (ADHAAR No., NAME, AGE). Which SQL command can be used to display records of all people whose age is 35? a. Select * from PEOPLE where AGE=35; b. Select * from PEOPLE where AGE is 35; c. Select * from PEOPLE such that AGE=35; d. None of these

Answer 1

Answer:

a. SELECT * from PEOPLE where AGE=35;

Syntax for select command is:

SELECT * from <table-name> where <condition>;