Hello
I have a one table and following field in table like id , name, product. I want to add the value in table after than find some product like in table 10 product exist then i want to find out product from 6-10 id please define how to find out?
Loading
Raja TPosted Sep 14, 2015, 9:32 AM
FROM table_name
WHERE column_name IN (value1,value2,...);
WHERE ID in (6,7,8,9,10);
Raja TPosted Sep 14, 2015, 9:16 AM
FROM table_name
WHERE column_name BETWEEN value1 AND value2;
WHERE ID BETWEEN 6 AND 10;
NitinPosted Mar 26, 2015, 9:24 AM
You can do this using this query:
Select * from tablename where id in(6,7,8,9,10)
OR
Select * from tablename where id between 6 and 10
Abhishek KumarPosted Sep 14, 2015, 9:00 AM