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 (678910); 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(678910) 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 Idnameproduct from Where Id IN(678910) or Select Idnameproduct from Where Id BETWEEN 6 and 10