Write a query that will display all movies with a return date of March 1, 2018, March 5, 2018, March 15, 2018, March 17, 2018 or March 25, 2018. Note: Do not use the OR operator for this query.
Write a query that will display all movies with a return date of March 1, 2018, March 5, 2018, March 15, 2018, March 17, 2018 or March 25, 2018. Note: Do not use the OR operator for this query.
Sql query to display all the movies with a return date of March 1, 2018, March 5, 2018, March 15, 2018, March 17, 2018 or March 25, 2018. Write the query without OR operator.
Create table query:
create table Movies(movieTitle varchar(10), movieYear int, movieReturnDate Date);
Insert some data in the table Movies using the insert query:
insert into Movies values('abc', 2018 ,'March 1, 2018');
insert into Movies values('cde', 2018 ,'March 3, 2018');
insert into Movies values('efg', 2018 ,'March 5, 2018');
insert into Movies values('ghi', 2018 ,'March 12, 2018');
insert into Movies values('ijk', 2018 ,'March 15, 2018');
insert into Movies values('jkl', 2018 ,'March 16, 2018');
insert into Movies values('lmn', 2018 ,'March 17, 2018');
insert into Movies values('mno', 2018 ,'March 19, 2018');
insert into Movies values('pqr', 2018 ,'March 21, 2018');
insert into Movies values('xyz', 2018 ,'March 25, 2018');
show the data stored in the Movie table using the select query:
select *
from Movies;
Step by step
Solved in 3 steps with 2 images
