Hello! Please help me understand. There is a table with a price column (int type) there are records 50, 75, 100 in it ... I am trying to output values ​​from 51 to 100

SELECT * FROM table WHERE price >= 51 AND price <= 100

 price BETWEEN 51 AND 100
  • doesn't work either

I get only 100, what's the problem?

  • missed the name of the column - Shadow33
  • Fixed price column - AndreyVitovtov
  • after AND also price <= 100 - Smithson

1 answer 1

SELECT * FROM table WHERE price> = 51 AND price <= 100

  • This is a query that you need. Above in the comments you write about the same. - Vadim Bondarenko
  • Sorry, a typo such a request does not work for me! - AndreyVitovtov
  • So there is no other value in the table. - Vadim Bondarenko
  • If "the table was incorrectly indicated, or the column name" would not receive anything, and so "I receive only 100"! - AndreyVitovtov
  • Make SELECT * FROM table Order by price - Vadim Bondarenko