Hi any shortcut to combine duplicate rows to one row ?

Hello Meghana,

SQL: Use the "GROUP BY" statement to group together all rows with the same values in certain columns. Then use aggregate functions (such as SUM, AVG, or COUNT) to combine the values in other columns. For example, if you have a table with columns for "Name," "Age," and "Salary," and you want to combine all rows with the same name into one row, you could use the following SQL statement:

SELECT Name, SUM(Age), SUM(Salary)
FROM MyTable
GROUP BY Name

This will give you one row for each unique name, with the total age and total salary for all rows with that name.

If you want to use a true DISTINCT only list out the column you want to receive distinct values of. If you have multiple columns then all those columns combined make up one distinct record.

You will have to show some sample data and an expected output.

Typically, DISTINCT clause is used for the purpose, however, more details are required.