display all customers with CustID from 10 to 100
display all customers with CustID above 10
display all customers with CustID below 100
display all customers with CustID from 11 to 99
Answer is Wrong!
Answer is Right!
The correct answer is D.
The query Select * from customer where CustID>10 and CustID<100 will return all customers with a CustID between 11 and 99. This is because the > and < operators are inclusive, meaning that all customers with a CustID of 11, 12, 13, and so on up to 99 will be returned.
Option A is incorrect because it would return all customers with a CustID from 10 to 100, including 10 and 100. Option B is incorrect because it would return all customers with a CustID above 10, including 11, 12, 13, and so on. Option C is incorrect because it would return all customers with a CustID below 100, including 99, 98, 97, and so on.