SQL Quiz..

[dasari4kntr]

read the comments...in this tweet...

its worth reading these comments...

 

 

 

[libraguy863]

1 hour ago, dasari4kntr said:

read the comments...in this tweet...

its worth reading these comments...

 

 

 

I think query 2 as the values are filtered with id=data.id  

 

but in the first query all the records are pulled from the sub query so thats my take .. explain me if im wrong.

[Konebhar6]

1 hour ago, dasari4kntr said:

read the comments...in this tweet...

its worth reading these comments...

 

 

 

I will delegate this to my team

[jalsa01]

5 hours ago, dasari4kntr said:

read the comments...in this tweet...

its worth reading these comments...

 

 

 

First query but Depends on big table size 

[dasari4kntr]

9 hours ago, libraguy863 said:

I think query 2 as the values are filtered with id=data.id  

 

but in the first query all the records are pulled from the sub query so thats my take .. explain me if im wrong.

 

6 hours ago, jalsa01 said:

First query but Depends on big table size 

it depends on the nulls bro…

check the tweet comments…lot of good discussion…

[DallasKarreBalu]

On 9/7/2023 at 8:54 AM, dasari4kntr said:

 

it depends on the nulls bro…

check the tweet comments…lot of good discussion…

ok

[Mr Mirchi]

when i design a table...i always try to avoid nulls with default values...if possible..

 

null ...c0rrest dasari

[Spartan]

1 hour ago, Mr Mirchi said:

when i design a table...i always try to avoid nulls with default values...if possible..

 

null ...c0rrest dasari

agree nulls should not be the default value 

[LungiLingaraju]

 No twitter account uncle