Only Few Seats Left for Advanced Certification Courses on Data Science, ML & AI by E&ICT Academy IIT RoorkeeApply Now
To select the rows meeting only certain criteria, use WHERE clause.
SELECT col1,col2 FROM table1 WHERE conditon1 AND/OR condition2 ..... SELECT col1,col2 FROM table1 WHERE (col1='123' and col2='456') OR col3='4';
select * from deptt where depcity = 'Mumbai'; select * from emp where empsal > 2300; select * from emp where empsal between 2400 and 2600;
All these operators can be used on the number as well as strings. When needed, numbers are implicitly converted into strings before comparison.
select * from deptt where depid like '%3%'; select * from deptt where depid like '%x%'; select * from deptt where depid = 'hello';
This 'where' clause can be used in insert/update/delete statements too.
No hints are availble for this assesment
Answer is not availble for this assesment