sql query for selecting multiple rows using where in one table.

Following queries helps to get the data from different rows in a table.

Select * from tablename where columnname in (‘a’, ‘b’);

Ex: Select * from TechnoVerve where name in (‘Admin’, ‘Super admin’, ‘Editor’);

Select * from tablename where columnname in (1, 2);

Ex: Select * from TechnoVerve where Salary in (50000, 10000, 20000);

Recent Posts