Enrollments Open for Certification Course on Artificial Intelligence and Deep Learning by 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