SQL Tricks | How to find value in multiple columns ?

Thanks!

Oh my goodness, its very very helpful... Many thanks to you.

Select gold as Player,count(1) from events k
where not Exists (Select * from events p where k.gold=p.silver)
and not exists (Select * from events C where k.gold=C.BRONZE)
group by GOLD

As per your example from Tbl1, If I want to find demo in col1, col2, col2, col4, col5 ? Pls reply

Hi ,
I want to find max date for each tables present in each schema how to write it dynamically

I learnt lot from this channel, good explanation ma'am

Nice Video.. But what if want to find only the Cancelled then in that case only two columns should appear..

Yes, this script is functional. But:
1. Dynamic queries are evil. Supporting such code is very time consuming
2. Code is vendor dependent and not portable
3. I can hardly imagine a situation where the table name is known in the database, but the column names are unknown or they can change arbitrarily. The above example shows that the base is not even in second normal form. This is not a base, but complete chaos. Instead of writing queries to this database, I would rather quit.

Excellent and will be great 💪🏼 if there is a way to loop all tables in a specific Database 🤔😏

Nice ma'am..👍

How to make this work in oracle

Great video ma'am

One question
where 'cancelled' in (col1,col2) is available just in SQL server or is it universal?

Please share more SQL tips and tricks.

Thanks for sharing

Hi Mam!
Can you do some mesium/ hard videos on sql leet code questions please...