Explain SQL joins,order by difference between delete and truncate.

Question

Accepted Answer

SQL joins combine data from two or more tables based on a related column. Order by sorts data in ascending or descending order. Delete removes rows from a table while truncate removes all rows.

SQL joins are used to combine data from two or more tables based on a related column.
Order by is used to sort data in ascending or descending order based on a specified column.
Delete removes rows from a table based on a specified condition.
Truncate removes all rows from a table and resets the identity seed value.
Inner join returns only the matching rows from both tables.
Left join returns all rows from the left table and matching rows from the right table.
Right join returns all rows from the right table and matching rows from the left table.
Full outer join returns all rows from both tables.
Order by can be used with multiple columns and can specify ascending or descending order.
Delete can be rolled back using a transaction while truncate cannot.
Delete triggers a delete trigger while truncate does not.

Explain SQL joins,order by difference between delete and truncate.

Popular interview questions of Information Technology Intern