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