Posts

Recent Post

Multi Bagger stock Filters

GROUP BY vs Window Functions in SQL

Using Window Functions Instead of Aggregate Functions in SQL CASE Statements

Advantages of CTE

RANK VS DENSE_RANK VS ROW_NUMBER

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

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

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

HPE VBA/SQL Interview questions

OLE DB vs ODBC vs ADODB

Connecting VBA to SQL

AI Stack

Index Investing