HomeНаука и техникаRelated VideosMore From: Chris Ostrowski

Oracle - Sub-Queries

19 ratings | 10165 views
Oracle - Sub-Queries
Html code for embedding videos on your blog
Text Comments (2)
Loved the way you chose to use artists as an attribute and Lou Reed as the value....the impression most IT pros have no clue about music..not true, m a sqlller and a screamer \../
JB (5 years ago)
Cool video. Just an observation. The query at the end of your video is not a correlated subquery, it returns a single value, so its a scalar / single row subquery. A correlated subquery is a query that CANNOT be executes outside of the main code block on it own, it depends on the main query to run, its related, hence the name.  select max(rating) from hr.music The above query can run independently from the parent query :)

Would you like to comment?

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