Cam someone help me….
I have to bookmark my SQL Query, i have to create a code to boormark all products within the tabel “album”, and the price must be between 3,00 and 4,00 But it doesnt work. Can someone tell me whats wrong?
Im new in SQL so sorry if its a dumb qeustion xD
Screenshot of the code down here.
https://gyazo.com/c85bfb44ccb326ac2f0c6652391e327e
SELECT * FROM `album` WHERE prijs BETWEEN 3,00 and 4,00;
Advertisement
Answer
asuming prjis is a valid number data type don’use comma for decimal
select * from album where prjis between 3.00 and 4.00;