Re: Sanity Check - Correlated Select Subquery SQL rewrite equivalent? Or no?

I so appreciate being part of this group of impressive thinkers.

I recall Kim Berg Hanson reading a SQL query I had on a slide and understanding it in seconds. I was like OMG, that was supposed to be an example of a difficult query.
Of course Jonathan is super impressive
An Mladen , thanks for the insightful pointers and exemple! Love that Chris pointed out the SQL. So many times I think the same thing about SQL , i.e. "this SQL 'breaks my brain.' " I personally more or less hate SQL. It's ironic that so much of my career revolves around it.
Its also why I'm super interested in ways of visualizing SQL as well as the potential to analyze SQL with methods like GPT.

Kyle

On Sun, Feb 5, 2023 at 9:28 AM Mladen Gogala <gogala.mladen_at_gmail.com> wrote:

> On 2/1/23 14:58, Laurentiu Oprea wrote:
>
> chat GPT says:
> what is the difference between the following two SQL queries?
>
> ChatGPT should be imbued with some of that charming Dirty Harry
> personality. That would be a good opportunity for some innocent fun.
>
> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217https://dbwhisperer.wordpress.com
>
>

--
http://www.freelists.org/webpage/oracle-l