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.
Correct Answer: (a) and (b) both are correct
Explanation:
Note: This Question is unanswered, help us to find answer for this one
More ASP.NET With SQL Server MCQ Questions