MCQs > IT & Programming > ASP.NET With SQL Server > You are maintaining data for its products in the Products table, and you want to see those products, which are 50 items that is currentStock or more than 50 but less than the minimum stock limit of items. The structure of the Products table is:

ASP.NET With SQL Server MCQs

You are maintaining data for its products in the Products table, and you want to see those products, which are 50 items that is currentStock or more than 50 but less than the minimum stock limit of items. The structure of the Products table is:

ProductID

ProductName

CurrentStock

MinimumStock

Two possible queries are:

(a)select * from products where currentStock > MinimumStock + 50

(b)select * from products where currentStock - 50 > MinimumStock

Choose the appropriate option with regard to the above queries.

Answer

Correct Answer: (a) and (b) both are correct

Explanation:

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

ASP.NET With SQL Server Skill Assessment

Overall Skill Level-Poor

Your Skill Level: Poor

Retake Quizzes to improve it

More ASP.NET With SQL Server MCQ Questions

search

ASP.NET With SQL Server Skill Assessment

Overall Skill Level-Poor

Your Skill Level: Poor

Retake Quizzes to improve it