Vivek Kumar
Author ProfileClaim This Author Profile
Prove ownership by publishing #HashtagPLUS and this profile link on your author page or an article under your byline. A moderator or admin will review the request before it merges into your real HashtagPLUS username.
π dev.toSource
From Dev.to - database: Multi-Tenant SQL Reporting: How to Show Each Customer Only Their Own Data
π dev.toSource
From Dev.to - database: Don't Trust AI-Generated SQL Blindly: A Developer's Validation Checklist
π dev.toSource
From Dev.to - database: Beyond Basics: Mastering SQL's LEAD, LAG, RANK, DENSE_RANK, and NTILE
π dev.toSource
From Dev.to - database: Beyond Basic Indexes: Mastering Partial, Composite, and Covering Indexes in SQL
π dev.toSource
From Dev.to - database: SQL String Functions: Clean, Transform, and Tame Messy Data Like a Pro
π dev.toSource
From Dev.to - database: SQL Date & Time Functions: A Practical Guide for Real-World Queries
π dev.toSource
From Dev.to - database: SQL GROUP BY & HAVING: The Beginner's Guide to Summarizing Data Like a Pro
π dev.toSource
From Dev.to - database: SQL Window Functions Explained: Stop Collapsing Your Data with GROUP BY
π dev.toSource
Searching for an exact value in a database is easy β you just use =. But what do you do when you only know part of the value? Maybe you want to find all customers whose email ends in @gmail.com, or all products with "pro" somewhere in the name. That's where SQL's LIKE operator co