Highness

@RealBenjizo Both are not same. Think of a case where category is Electronics and price is 50. First query won't return anything where as second query will return this record.

🚨 Avoid CASE in the WHERE Clause One of the most common SQL anti-patterns is using CASE inside the WHERE clause to handle conditional logic on ranges or filters. Here's a classic example: SELECT * FROM products WHERE CASE WHEN category = 'Electronics' THEN price < 500 ELSE price < 100 END; It works, but it usually kills performance because the CASE expression makes the predicate non-SARGable in most major databases. The optimizer can't effectively seek into an index on price (or a composite (category, price) index). You often end up with full table scans, even when you have great indexes. SELECT * FROM products WHERE price < 100 OR (category = 'Electronics' AND price < 500); 👑 This version is better because it simplifies the logic and avoids unnecessary conditions. This makes the query easier to read, easier to maintain, and easier for the optimizer to reason about since the predicates are straightforward and not wrapped in extra logical branching. 📙 SQL Essentials for Data Analysis is now Available link: benjaminb.gumroad.com/l/hkkmf

@neerajjj6785 Notepad++

Name a tool with 0 haters. I’ll start: GitHub.

@Portfolio_Bull @grok ofss full form?

Profit Per Employee of IT Companies 🤯 1) OFSS~ ₹26.15 Lakh 2) Infosys~ ₹8.3 Lakh 3) TCS~ ₹8.2 Lakh 4) HCL Tech~ ₹7.3 Lakh 5) Persistent~ ₹6.5 Lakh 6) Mphasis~ ₹5.8 Lakh 7) Wipro~ ₹5.5 Lakh 8) LTI Mindtree~ ₹5.4 Lakh 9) Coforge~ ₹3.9 Lakh 10) Tech Mahindra~ ₹3.1 Lakh OFSS makes highest profit per employee :)

@FI_InvestIndia Where to get this Sarvam app ? Don't see in android app store

Daily limit for Indus by Sarvam AI OVER? It asked me to wait for 24 hours. So this is what I did. I went to Settings. Clicked on Delete my Account. My account was deleted. I logged in again with my phone number and OTP 🔥 Works ❤️ Real Intelligence always works... #FI

@ValueResearch Hello @JioCare .Why @ValueResearch team is saying its only problem with jio network?

@oyehoyee_ We regret the inconvenience caused. Could you please confirm if you are using a Jio network for internet connectivity. If you are using a different network and still facing the issue, kindly write to us at help@valueresearch.in so we can investigate further.

@ValueResearch why ur website is damn slow more than half of the day , everyday

@charliejhills LOCAL

Run a full coding agent locally. No API bills. No limits. No data leaving your machine. Private. Powerful. 100% free. I made a step-by-step guide anyone can follow in minutes. To get it, just: → Like + Repost → Comment “LOCAL” → Follow me (so I can DM)

@SumitM_X Reset to the number where it started from while creating that column in SQL Server

What happens if Database's auto-increment ID runs out?

@ehansalytics They might be planning to give you 4 VMs to work in parallel 😄

Me: Hi IT Department. I need a VM set up to host a Power BI Gateway. Ideally it would have 32GB of RAM, but 16GB should work for this application if that is all you have. IT Dept: Sure! Here is your VM. It has 8GB of RAM. Enjoy!

@SumitM_X Agree

Even if you are better at work ...a well prepared candidate will get the job..

@SanjuJsp New Name - Roman Singh

@utsavtechie @grok what exactly this means?

Google is slowly rolling out a new feature that lets users change their @ gmail . com email address, something people have been asking for for years.

@Darkdarling00 A

“If a mother’s name is 62 A son’s name is 52 A daughter’s name is 42 What is the name of the father?”

@MayMayspeaks She is playing chess

@JSKSA20 .

The only time you’ll pray for zero likes! 🫶🏼👕 #WhistleForJoburg #ToJoburgWeBelong

@grok , list 10 best cities to live with best air quality in odisha with cheap living cost

@bikiprasad28 @kunalstwt @grok list top 10 cities in india with least AQI and cheap to licet

it's the same in Pune as well, not sure which indian city has clean air to breathe anymore. I can smell the smoke and taste the pollution entering my body. Down with a sore throat and constant sneezing for 2 days. I was in Assam a few days back breathing pristine air but had to come back because of mandatory WFO 😫.

Leave Delhi, go in debt if you have to. I used to think, how bad can the AQI really be for people in Delhi? I knew it was bad, but I never understood the scale because I didn’t feel it as drastically. I grew up in Delhi, studied here, and never felt a huge difference. You see people on the streets without masks, just walking around, and even people going for morning runs. But I was wrong. It’s a crisis. And honestly, leaving this city should be your top priority. After living in London for a few years and breathing clean air, the moment I landed in Delhi I could literally taste and smell the pollution. Even AQI 200 hit me hard: sore throat, and a feeling like needles in my lungs. I could actually feel the pollution entering my body. Please leave this city for your own sake. Buying a property here does not make sense either. Same for Mumbai. If you can, pack your bags and move yourself and your work somewhere else. I’ve cut my trip short and I’m leaving this city tomorrow.