[Solved] Which of the following is the correct syntax to filter rows where Price is less than 50? - Ans: SELECT * FROM Products WHERE Price < 50; | C Sharp (C#)

C Sharp (C#) - LINQ Fundamentals

Which of the following is the correct syntax to filter rows where Price is less than 50?

ASELECT * FROM Products WHERE Price LESS 50;

BSELECT * FROM Products WHERE Price = < 50;

CSELECT * FROM Products WHERE Price < 50;

DSELECT * FROM Products WHERE Price IS LESS THAN 50;

Step-by-Step Solution

Solution:

Step 1: Review correct SQL comparison syntax
The less than operator is < and is used as 'Price < 50' in WHERE clause.
Step 2: Identify syntax errors in other options
SELECT * FROM Products WHERE Price = < 50; has wrong operator usage, C and D use invalid keywords not recognized in SQL.
Final Answer:
SELECT * FROM Products WHERE Price < 50; -> Option C
Quick Check:
Use < operator for less than in WHERE [OK]

Quick Trick: Use <, >, = operators directly in WHERE [OK]

Common Mistakes:

MISTAKES

Master "LINQ Fundamentals" in C Sharp (C#)

9 interactive learning modes - each teaches the same concept differently

More C Sharp (C#) Quizzes

Which of the following is the correct syntax to filter rows where Price is less than 50?