> > >

SQL MCQs

Which will select the `name` of 'John' from the 'Person' table where `num_friends` is greater than 1?

SELECT * FROM Person WHERE num_friends MORE THAN 1 AND name = 'John'

SELECT "John" as 'name' FROM `Person` WHERE `num_friends` > 1

SELECT name FROM Person WHERE num_friends > 1 AND name = 'John'

SELECT CONCAT(firstname, lastname) FROM Person WHERE num_friends > 1 AND name = "John"

Answer

Correct Answer: SELECT name FROM Person WHERE num_friends > 1 AND name = 'John'

Explanation:

Note: This Question is unanswered, help us to find answer for this one

SQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it