MCQs > IT & Programming > LAMP > Food Cart Accounting System (FOCAS) is maintaining products in the products table, and wants to see the products which are 50 or more than 50 short of the minimum stock limit. The structure of the Products table is: ProductID ProductName CurrentStock MinimumStock Two possible queries are: Query 1:select * from products where currentStock>MinimumStock+50 Query 2:select * from products where currentStock-50>MinimumStock Which is correct?

LAMP MCQs

Food Cart Accounting System (FOCAS) is maintaining products in the products table, and wants to see the products which are 50 or more than 50 short of the minimum stock limit. The structure of the Products table is:
        ProductID
        ProductName
        CurrentStock
        MinimumStock

Two possible queries are:

Query 1:select * from products where currentStock>MinimumStock+50

Query 2:select * from products where currentStock-50>MinimumStock

Which of the following is correct?

Answer

Correct Answer: Both the queries are true

Explanation:

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

LAMP Skill Assessment

Overall Skill Level-Poor

Your Skill Level: Poor

Retake Quizzes to improve it

search

LAMP Skill Assessment

Overall Skill Level-Poor

Your Skill Level: Poor

Retake Quizzes to improve it