SQL

Transaction and ACID properties: A set of statements executed on a resource or resources applied with ACID properties is known as Transaction. Note: Here database is one resource but resource need not be only database. ACID Properties: …

What is the difference between sub query and co-related subquery: Sub Query: Here inner query gets executed first and based on the result of it the outer query is executed…

Implementation of relationships in sql: We have three types of relationships in SQL. one-to-one; one-to-many; many-to-many…

When should we use GROUP BY clause: When there is a need to aggregate/group values in a column based on some criteria in same/another column then we go for GROUP BY clause. Usage of Aggregate function on column: col_sales: …

Difference between ‘where’ and ‘having’ clause: ‘where’ clause is used to apply a condition on an column directly…

Difference between ‘distinct’ and ‘group by’ clauses: ‘distinct’ keyword is used to remove duplicates…