Manish Sharma

You learn one SQL command… and assume it works everywhere.
Then you switch databases, and suddenly nothing works.


That’s where most people get stuck.

Skip the Carousel

1 2 3 4 5 6 7 8 9

1 day ago | [YT] | 107

Manish Sharma

SQL interview questions explained: NULL vs 0 vs empty string with real examples

Master tricky SQL interview concepts and avoid common mistakes in database queries

buying link: dataprofy.com/product-category/ebook/

Skip the Carousel

1 2 3 4 5 6 7 8 9

3 days ago | [YT] | 184

Manish Sharma

Enroll now - www.dataprofy.com/sqltraining/

1 week ago | [YT] | 96

Manish Sharma

Most developers solve this SQL interview question using CASE WHEN.

But if you work with Oracle, there’s also a shorter trick using DECODE.

In this post I’ve shown both approaches.

Check the pinned comment for the enrollment link to my Live SQL training.

#sql #sqlinterview #learnsql

Skip the Carousel

1 2 3 4 5 6 7

1 week ago | [YT] | 160

Manish Sharma

Skip the Carousel

1 2 3 4 5 6 7 8

3 weeks ago | [YT] | 252

Manish Sharma

Skip the Carousel

1 2 3 4 5 6 7

4 weeks ago | [YT] | 256

Manish Sharma

Only Top 1% can answer this SQL interview Questions.

Comment "SQL" if you want more SQL interview Questions

4 weeks ago | [YT] | 113

Manish Sharma

What is the result of the following query in Oracle?

SELECT 'True' AS Result
FROM DUAL
WHERE '' IS NULL;

4 weeks ago | [YT] | 13

Manish Sharma

Only Top 1% can answer this SQL interview Questions.

Comment "SQL" if you want more SQL interview Questions

4 weeks ago | [YT] | 93

Manish Sharma

Only Top 1% can answer this SQL interview Questions. How many types of subqueries do we have?

Comment "SQL" if you want more SQL interview Questions

4 weeks ago | [YT] | 116