SQL Tutorials - myTechMint

SQL (Structured Query Language) – Injection

If you take a user input through a webpage and insert it into a SQL database, there is a chance that you have left yourself …

SQL (Structured Query Language) – Handling Duplicates

There may be a situation when you have multiple duplicate records in a table. While fetching such records, it makes more sense to fetch only …

SQL (Structured Query Language) – Using Sequences

A sequence is a set of integers 1, 2, 3, … that are generated in order on demand. Sequences are frequently used in databases because …

SQL (Structured Query Language) – Sub Queries

A Subquery or Inner query or a Nested query is a query within another SQL query and embedded within the WHERE clause. A subquery is …

SQL (Structured Query Language) – Clone Tables

There may be a situation when you need an exact copy of a table and the CREATE TABLE … or the SELECT… commands does not …

SQL (Structured Query Language) – Temporary Tables

What are Temporary Tables? There are RDBMS, which support temporary tables. Temporary Tables are a great feature that lets you store and process intermediate results by using …

SQL (Structured Query Language) – Date Functions

The following table has a list of all the important Date and Time related functions available through SQL. There are various other functions supported …