SQL & Databases

Queries that will not behave, schema design, indexes and query plans.

3 threads · 11 messages

SolvedNOT IN with a subquery returns nothing and I cannot see why

Samuel Okafor · 1 month ago

2

Replies

467

Views

1 month agoSamuel Okafor

SolvedCOUNT(*) and COUNT(column) give me different numbers

Leilani Kahale · 1 month ago

3

Replies

471

Views

1 month agoLeilani Kahale

SolvedMy LEFT JOIN behaves like an INNER JOIN when I add a WHERE clause

Rafael Mendes · 2 months ago

3

Replies

840

Views

2 months agoPriya Nair