HomeОбразованиеRelated VideosMore From: Imtiaz Ahmad

Lesson 8 - SQL BETWEEN, IN and More Filtering (Oracle SQL Certification)

45 ratings | 4191 views
In this lesson we continue on from the last lesson and dive deeper into query filtering using the BETWEEN, IN and NULL keywords
Html code for embedding videos on your blog
Text Comments (7)
SlyPanther (3 hours ago)
I did SELECT ENAME, HIREDATE FROM EMP, DEPT WHERE LOC = 'DALLAS' OR LOC = 'CHICAGO' and got the same result SELECT ENAME, HIREDATE FROM EMP, DEPT WHERE LOC in ('DALLAS', 'CHICAGO')
At 12:47 I had an error because you must match the date clause querry to the date format you have in the tabel. For me it worked >>> WHERE hiredate BETWEEN '05-JUN-1981' AND '12-SEP-1982'; <<<
Angel Nguyen (3 months ago)
High quality tutorials. Thank you!
Nie Frank (7 months ago)
Very good
RAHIM DOBANI (1 year ago)
I like your pace and details with which you go over each topic. Good Job. I found you on Udemy will go for full course there.
Lucas Pizarro (1 year ago)
muchas gracias amigo saludos desde peru
Lucas Pizarro (1 year ago)
very good

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.