SQL – Transactions Table of content SQL Transactions A transaction is a unit or sequence of work that is performed on a database. Transactions are accomplished in a logical order, whether in a manual fashion by a user or automatically by some sort of a database program. A transaction is the propagation of one or […]
Category Archives: sql
SQL – Sub Queries Table of content SQL Subqueries An SQL Subquery, is a SELECT query within another query. It is also known as Inner query or Nested query and the query containing it is the outer query. The outer query can contain the SELECT, INSERT, UPDATE, and DELETE statements. We can use the subquery […]
SQL – Handling Duplicates Table of content Sometimes, tables or result sets contain duplicate records. While in most cases, duplicates are allowed, there are situations where it is necessary to prevent duplicate records and remove them from a database table. Why is Handling Duplicates in SQL Necessary? Handling duplicates in an SQL database becomes necessary […]