5. difference between truncate, delete and drop 6. difference between union and union all 7. He asked to solve SQL questions involving percentages and another one with rank

Question

Accepted Answer

Answers to SQL-related questions for Product Business Analyst position

Truncate is a DDL command that removes all rows from a table without logging the individual row deletions, while delete is a DML command that removes specific rows from a table and logs each deletion
Drop is a DDL command that removes an entire table from the database
Union combines the results of two or more SELECT statements into a single result set, while Union All includes all rows from each SELECT statement, even if there are duplicates
SQL questions involving percentages can be solved using the formula (part/whole)*100, while ranking can be done using the RANK() function

5. difference between truncate, delete and drop 6. difference between union and union all 7. He asked to solve SQL questions involving percentages and another one with rank

Popular interview questions of Product Business Analyst