Computer Science · SQL Queries
A store manager wants to list all products priced between 500 and 1000 inclusive, but exclude products marked as out of stock ('No' in Stock column). Which query satisfies this condition?
Verified Solution4 OptionsUpdated: October 2026👁️1 View
Share:
- 1SELECT * FROM Products HAVING Price BETWEEN 500 AND 1000;
- 2SELECT * FROM Products WHERE Price BETWEEN 500 AND 1000 AND Stock!='No';✓
- 3SELECT * FROM Products WHERE Price IN (500,1000) AND Stock!='No';
- 4SELECT * FROM Products WHERE Price BETWEEN 500 AND 1000 OR Stock='No';
Correct answer
SELECT * FROM Products WHERE Price BETWEEN 500 AND 1000 AND Stock!='No';
Download Single Question PDF
Save this question and verified answer as a clean study sheet with live clickable link.
👥
Share with Friends & Study Groups
Challenge your peer aspirants on WhatsApp or Telegram to solve this question!
Online Test Series
Start Free Mock Test →Preparing for Computer Science?
Practice full-length mock tests with real exam timers, instant score analysis, and all-India ranking.
Chapter Practice
Practice SQL Queries MCQs →Want more practice questions on SQL Queries?
Solve complete topic-wise tests with detailed solutions on GkGet.
Related Practice Questions
Recommended practice questions in Computer Science · SQL Queries