Posts

Recent Post

GROUP BY vs Window Functions in SQL

on
0

Using Window Functions Instead of Aggregate Functions in SQL CASE Statements

on
0

Advantages of CTE

on
0

RANK VS DENSE_RANK VS ROW_NUMBER

on
0

Why NOT LIKE Returned Only 28 Records Instead of 44,000 in SQL

on
0

Why a FULL OUTER JOIN Returned Fewer Records Than Expected in SQL

on
0

Providing Workspace-Level and RLS Access to an External Vendor in Power BI

on
0

HPE VBA/SQL Interview questions

on
0

OLE DB vs ODBC vs ADODB

on
0

Connecting VBA to SQL

on
0

AI Stack

on
0

Index Investing

on
0

Factor investing

on
0