How to pick the first row in a join to avoid duplicate records in SQL
One of the common problem that we may face during joining multiple tables in a SQL is we want only one row across the entire tables even if we have duplicate records. Consider the following tables In a given scenario, we have customers, invoices and items table. Now we want to list down a summary…