Skip to content

myTechMint

  • Tech Tips
  • How To
  • Exam Prep
  • Tutorials
  • Placement Prep
  • B.Tech
  • CBSE

SQL Tutorials

Understanding the SQL CASE Statement with Examples

SQL - Structured Query Language Tutorials

The CASE statement in SQL returns a value for the condition specified. It tests a list of conditions and returns one of the multiple possible …

Read More ➜

SQL (Structured Query Language) – Injection

SQL Tutorials myTechMint

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 …

Read More ➜

SQL (Structured Query Language) – Handling Duplicates

SQL Tutorials myTechMint

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 …

Read More ➜

SQL (Structured Query Language) – Using Sequences

SQL Tutorials myTechMint

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

Read More ➜

SQL (Structured Query Language) – Sub Queries

SQL Tutorials myTechMint

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 …

Read More ➜

SQL (Structured Query Language) – Clone Tables

SQL Tutorials myTechMint

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

Read More ➜

SQL (Structured Query Language) – Temporary Tables

SQL Tutorials myTechMint

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 …

Read More ➜

SQL (Structured Query Language) – Date Functions

SQL Tutorials myTechMint

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

Read More ➜

Post navigation
Older posts
Page1 Page2 … Page6 Next →

Have Questions?

Ask you Question here.

Categories

  • AWS Tutorials
  • B.Tech
  • Banking Exam
  • CBSE
  • Certification
  • Class 11
  • Class 12
  • Computer Science
  • Electronics & Communication
  • Electronics & Communication
  • Exam Preparation
  • GATE
  • Government Jobs
  • Hive Tutorials
  • How To
  • IT Jobs
  • JEE
  • Job Alert
  • Linux Tutorials
  • Mechanical Engineering
  • Placement Preparation
  • PySpark Tutorial
  • Python Tutorials
  • SQL Tutorials
  • Sqoop Tutorials
  • SSC
  • Talend Tutorials
  • Tech News
  • Tech Tips
  • Tutorials
  • Unix Tutorials
  • UPSC
  • VBA Tutorials

Recommended Posts

  • NCERT Solutions for Class 11 Chemistry Chapter 7 – Equilibrium
  • NCERT Solutions for Class 11 Chemistry Chapter 6 – Chemical Thermodynamics
  • NCERT Solutions for Class 11 Chemistry Chapter 5 – States of Matter
  • NCERT Solutions for Class 11 Chemistry Chapter 4 – Chemical Bonding and Molecular Structure
  • NCERT Solutions for Class 11 Chemistry Chapter 3 – Classification of Elements and Periodicity in Properties

Footer Menu

  • About
  • Contact
  • Sitemap
  • Privacy Policy
Copyright © 2016 - 2022 myTechMint