Question

The SQL statement to display the list(with all fields in the table) of all pets with gender (field name - sex) as male (field value - m) from table pet
1 point

SELECT * FROM pet WHERE sex = 'm'

RETRIEVE * FROM pet WHERE sex = 'm'

FIND * FROM pet WHERE sex = 'm'

None​

Answer 1

Answer:-

The Correct Option is a)

SELECT*FROM pet WHERE sex = 'm'

As syntax for select statement which displays the result according to condition is:-

SELECT*FROM <TABLE NAME> WHERE <CONDITION>