I've encountered this issue, but it was because the column included the date AND time. For example, in the UPDATE_DATE column a row in my table has the value 1969-12-31 07:01:39. If I search BETWEEN 1969-01-01 and 1969-12-31 it's really searching 1969-01-01 00:00:00 and 1969-12-31 00:00:00. Since my data occurred AFTER 1969-12-31 00:00:00 it will not be returned. If that is actually the case then you would want to query BETWEEN 1969-01-01 00:00:00 and 1969-12-31 23:59:59. I hope that helps.
43:19 “spin-odd” or “spin-off”? I found this video is useful with some tips. The level is beginner-intermediate, I think. In general, I like this course but the lecturer always makes errors (“typo”) and for a code/programmer/developer it is a not good trait; those ppl have to be Perfectionists! Please answer re. “Spin-odd”. I hope it is an error and not a new term. Thank you.
how could you possibly call this advanced. this is like "hi I know sql basics, now I'd like to see what else it can do.. but not too much b/c I'm not an engineer an thus I obviously give up quick".
Please study cyber-security and modern database implementation, at least for a few minutes. I worry about the vulnerability surface your students are going to bring to their companies
very fine.prof a.paramasivam,sivaganga,india
I appreciate the video's rawness and live realistic examples. Superb and enthusiastic teaching with real querying creations. Thank you!
This is great video. Precise and content. But this is more of a basics of sql.
This was really well put together. Lots to work on. Thanks for making it simple to follow and easily relatable.
Really good and informative
Any possible to provide data
This was SO helpful for me. Thank you so much!!
What a great tutorial! Thank you, sir!
Thank you for sharing this video. However I was expecting something more advanced. This is kind of introductory queries.
this is very helpful,it helps my job, thank you
Great Video. Thank you for posting.
Very useful... Thank you
nice video
Thanks for making this video. Is there anywhere that I can get the data?
where can I find the databases used in this video ?
Would it be possible to get a copy of the database you used?
where i can get the database? any link to download
U know what ....that is great...
No for the date "between" keyword does not include last day, if the date is 12-31-1969 it will get records till 12-30-1969. Please confirm.
I've encountered this issue, but it was because the column included the date AND time. For example, in the UPDATE_DATE column a row in my table has the value 1969-12-31 07:01:39. If I search BETWEEN 1969-01-01 and 1969-12-31 it's really searching 1969-01-01 00:00:00 and 1969-12-31 00:00:00. Since my data occurred AFTER 1969-12-31 00:00:00 it will not be returned. If that is actually the case then you would want to query BETWEEN 1969-01-01 00:00:00 and 1969-12-31 23:59:59. I hope that helps.
is this MySQL compatible?
Thank you very much
43:19 “spin-odd” or “spin-off”? I found this video is useful with some tips. The level is beginner-intermediate, I think. In general, I like this course but the lecturer always makes errors (“typo”) and for a code/programmer/developer it is a not good trait; those ppl have to be Perfectionists! Please answer re. “Spin-odd”. I hope it is an error and not a new term. Thank you.
Nice
Some of these statements with subselect will take A LOT OF TIME to execute when DBSize > 10m+- records
Then how to go about it?
This is an advanced video?
He sounds like dan from roseanna
how could you possibly call this advanced. this is like "hi I know sql basics, now I'd like to see what else it can do.. but not too much b/c I'm not an engineer an thus I obviously give up quick".
Did you find a video which has more advanced queries. Can you please share?
@@ghr6518 th-cam.com/video/vE8UcS8U_xE/w-d-xo.html
Please study cyber-security and modern database implementation, at least for a few minutes. I worry about the vulnerability surface your students are going to bring to their companies
Never knew between clause was advanced sql...
sir £ sir$ sor
Riazul Mriddu h la y
College classes on this topic are boring as hell and useless.
"Advanced"? C'mon, click bait..