Home > Blog > Database

Articles (212)

How to Retrieve Data From Multiple Tables in SQL Category Image
Article
How to Retrieve Data From Multiple Tables in SQL?
By Yash Vardhan Gupta
Updated on: Feb 03, 2026
SQL Join vs Subquery Category Image
Article
SQL Join vs Subquery
By Yash Vardhan Gupta
Updated on: Aug 05, 2025
How to Select 10 Random Rows from 600K Rows Fast in MySQL Category Image
Article
How to Select 10 Random Rows from 600K Rows Fast i...
By Yash Vardhan Gupta
Updated on: Feb 03, 2026
How to Disable ONLY FULL GROUP BY in MySQL Category Image
Article
How to Disable  ONLY_FULL_GROUP_BY in MySQL?
By Yash Vardhan Gupta
Updated on: Feb 02, 2026
sql update blog image 2
Article
SQL UPDATE with INNER JOIN in Oracle
By Yash Vardhan Gupta
Updated on: Feb 03, 2026
INNER JOIN ON vs WHERE clause in MySQL Blog
Article
INNER JOIN ON vs WHERE clause in MySQL
By Yash Vardhan Gupta
Updated on: Feb 03, 2026
How to Split a Delimited String to Access Individual Items in SQL Blog
Article
How to Split a Delimited String to Access Individu...
By Yash Vardhan Gupta
Updated on: Feb 03, 2026
Convert Rows to Columns Using Pivot in SQL Server Category Image
Article
Convert Rows to Columns Using ‘Pivot’ ...
By Yash Vardhan Gupta
Updated on: Jul 08, 2025
How to Create an AUTO INCREMENT ID on Oracle Blog
Article
How to Create an AUTO_INCREMENT ID on Oracle?
By Yash Vardhan Gupta
Updated on: Feb 03, 2026
How to Split a Comma separated Value CSV into Columns in SQL Blog
Article
How to Split a Comma-separated Value (CSV) into Co...
By Yash Vardhan Gupta
Updated on: Feb 03, 2026
Difference between UNION and UNION ALL in SQL blog
Article
Difference between UNION and UNION ALL in SQL
By Yash Vardhan Gupta
Updated on: Feb 03, 2026
Blog 2 2
Article
How to Get the Last Record in Each Group Using MyS...
By Yash Vardhan Gupta
Updated on: Feb 03, 2026
Feature 1 1
Article
How to Efficiently Convert Rows to Columns in SQL ...
By Yash Vardhan Gupta
Updated on: Feb 03, 2026
How to Select Rows with Max Value on a Column in SQL Blog
Article
How to Select Rows with Max Value on a Column in S...
By Yash Vardhan Gupta
Updated on: Feb 03, 2026
Insert into a MySQL table or update if exists Blog
Article
Insert into a MySQL table or update if exists
By Yash Vardhan Gupta
Updated on: May 27, 2025

Tutorials (5)

Interview Questions (13)

Webinars (0)