Filtering

Which keyword is used for filtering in SQL?

• FILTER

• WHERE

• SELECT

• FROM

Which one is "greater than"?

• <

• >=

• >

• <>

Which one is "less than or equal to"?

• <=

• =

• <>

• <

Which one is "not equal to"?

• <=

• =

• !=

• <>

What is the condition for <?

• Equal to

• Greater than or equal to

• Less than or equal to

• Less than

What is the condition for =?

• Greater than or equal to

• Greater than

• Equal to

• Not equal to

Which of the followings is a correct way to use filter in query?

• SELECT * FROM Person house=1

• SELECT * FROM House FILTER id>30

• SELECT first_name FROM Person WHERE house=2

• SELECT id, first_name FROM Person WHERE 2

Which query will request all "Griffindor" students?

• SELECT * FROM Person

• SELECT * FROM Person WHERE id=1

• SELECT * FROM Person WHERE house<>1

• SELECT * FROM Person WHERE house=1

Which query will request all people whose id is greater than 90?

• SELECT * FROM Person WHERE id>90

• SELECT * FROM House WHERE id>90

• SELECT * FROM Person WHERE id>=90

• SELECT * FROM Person WHERE house>90

How many rows will be shown if following query is requested SELECT name FROM House WHERE id=4 ?

• 2

• 3

• 4

• 1