Write Query

Question

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?

Raja T · Answer

Hi Davin Martyn, Syntax SELECT column_name(s) FROM table_name WHERE column_name IN ( value1 , value2 ,...); Example SELECT id , name, product FROM tbl_Products WHERE ID in (6,7,8,9,10); More details checkout bellow url http://www.w3schools.com/sql/sql_in.asp

Raja T · Answer

Hi Davin Martyn, Syntax SELECT column_name(s) FROM table_name WHERE column_name BETWEEN value1 AND value2; Example SELECT id , name, product FROM tbl_Products WHERE ID BETWEEN 6 AND 10; More details checkout bellow url http://www.w3schools.com/sql/sql_between.asp

Nitin · Answer

Hi, 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 Kumar · Answer

Hi, You can use between or In keyword with Where clause. such as :- Select Id,name,product from Where Id IN(6,7,8,9,10) or Select Id,name,product from Where Id BETWEEN 6 and 10

Write Query

Answers (4)