Home > Blog > Database

Articles (212)

How to SELECT Rows with MAX PARTITION BY Another Column in MySQL Blog
Article
How to SELECT Rows with MAX PARTITION BY Another C...
By Yash Vardhan Gupta
Updated on: Jul 22, 2025
SQL INSERT INTO SELECT Statement Blog
Article
SQL INSERT INTO SELECT Statement
By Yash Vardhan Gupta
Updated on: May 27, 2025
How to Escape a Single Quote in SQL Server Blog image
Article
How to Escape a Single Quote in SQL Server?
By Yash Vardhan Gupta
Updated on: Jul 20, 2025
NOT IN vs NOT EXISTS Blog
Article
NOT IN vs NOT EXISTS in SQL
By Yash Vardhan Gupta
Updated on: Jun 28, 2025
Feature 33
Article
How to Concatenate Text from Multiple Rows into a ...
By Yash Vardhan Gupta
Updated on: May 27, 2025
How to limit the rows returned by an Oracle query after ordering Category Image
Article
How to limit the rows returned by an Oracle query ...
By Yash Vardhan Gupta
Updated on: May 27, 2025
Difference between INNER JOIN and OUTER JOIN in SQL Blog
Article
Difference between INNER JOIN and OUTER JOIN in SQ...
By Yash Vardhan Gupta
Updated on: Jul 31, 2025
How to Select the First Row in Each GROUP BY Group in SQL Blog
Article
How to Select the First Row in Each GROUP BY Group...
By Yash Vardhan Gupta
Updated on: May 27, 2025
How to UPDATE with JOIN in SQL Server Blog
Article
How to UPDATE with JOIN in SQL Server?
By Yash Vardhan Gupta
Updated on: Jul 20, 2025
How to UPDATE from a SELECT in SQL Server Blog
Article
How to UPDATE from a SELECT in SQL Server?
By Yash Vardhan Gupta
Updated on: May 27, 2025
Intellipaat
Article
SQL Subquery: A Step-By-Step comprehensive Guide
By Yash Vardhan Gupta
Updated on: Jul 29, 2025
Window Functions in SQL Category Image
Article
Window Functions in SQL
By Yash Vardhan Gupta
Updated on: Jul 25, 2025
Pivot and Unpivot Operations IN SQL Category Image
Article
Pivot and Unpivot in SQL
By Yash Vardhan Gupta
Updated on: May 27, 2025
Intellipaat
Article
Common Table Expression (CTE) in SQL
By Yash Vardhan Gupta
Updated on: Jul 24, 2025
SQL Server Transactions Blog
Article
SQL Server Transactions
By Yash Vardhan Gupta
Updated on: Nov 17, 2025

Tutorials (5)

Interview Questions (13)

Webinars (0)