Multiple choice

How can we select all the records from a table named company list where the value of the column company is IBM?

  1. Select [all] from company list where company = IBM

  2. Select * from company list where company = IBM

  3. Select * from company list where company = ibm

  4. Select * * from company list where company = IBM
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The where clause is used to limit the effect of a select/delete/update to only those records that meet the given condition. The above statement will display all those records where company is IBM. Although SQL is a case insensitive language, special care must be taken while comparing a text value with another since it matches the text and the case also.

Keep practicing — related questions