Which SQL query will return all the records from the table named ‘Student’ whose department name (dept_name) includes the substring ‘IT’.
1
select * from Student where dept_name like ’IT%’;
2
select * from Student where dept_name like ’%IT’;
3
select * from Student where dept_name like ’IT’;
4
select * from Student where dept_name like ’%IT%’;