SQL Tricks | How to find value in multiple columns ?

[@gustavoadolfogomezacevedo3905]

Thanks!

[@LearnatKnowstar]

Thank you so much for your support 🙏

[@swathiambi3849]

Excellent!! Thank you!

[@shekhark1139]

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

[@LearnatKnowstar]

Thank you

[@smcgpra3874]

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

[@LearnatKnowstar]

Glad to hear that

[@amukelaniebenezer406]

Thanks for sharing

[@LearnatKnowstar]

Thank you

[@rk-ej9ep]

Nice ma'am..👍

[@LearnatKnowstar]

Thank you

[@abdullahquhtani4247]

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

[@LearnatKnowstar]

Thank you. May need to write a stored procedure to loop through all table names.

[@yallasailakshmankumar2714]

You can use EXEC sp_MSforeachtable, example for records count,EXEC sp_MSforeachtable 'SELECT ''?'' TableName, Count(1) NumRecords FROM ?'

[@kristyowens2284]

Please share more SQL tips and tricks.

[@LearnatKnowstar]

Sure. More sql tips coming soon.

[@sivachandar5705]

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

[@AnandKumar-dc2bf]

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

[@LearnatKnowstar]

Sure. We are planning something soon. Stay tuned 👍

[@samarif6467]

Can I use it for NULL in each of the columns

[@maheshp5244]

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

[@avi8016]

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

[@LearnatKnowstar]

Thank you. Might not work in all databases.

[@hoperight5280]

I tried to perform it in pgadming and worked.

[@siddheshamrutkar8684]

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

[@LearnatKnowstar]

It will output the whole record because we are performing a Select *.

[@rajeshbandari20041989]

How to make this work in oracle

[@LearnatKnowstar]

If this does not work in oracle, then an or in where clause can always be used to compare each and every column value.

[@nakuldeep7336]

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

[@nikolaybaranov2213]

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.

[@LearnatKnowstar]

Thank you for your comments. They are always insightful and knowledgeable. Yes, I agree this is not the best example of writing a code and should be used just as a quick trick for simpler requirements.