Home > Blog > Database

Articles (212)

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
Oracle IDENTITY Column for Auto Incrementing IDs Category Image
Article
Oracle IDENTITY Column for Auto-Incrementing IDs
By Yash Vardhan Gupta
Updated on: Feb 03, 2026
How Can I Group by Date Time Column Without Taking Time Into
Article
How Can I Group by Date-Time Column Without Taking...
By Yash Vardhan Gupta
Updated on: Feb 03, 2026
feature 35
Article
How can I get column names from a table in Oracle
By Yash Vardhan Gupta
Updated on: Feb 03, 2026
How to Use GUID for Auto Incrementing IDs in Oracle Category Image
Article
How to Use GUID for Auto-Incrementing IDs in Oracl...
By Yash Vardhan Gupta
Updated on: Feb 03, 2026
FOR XML PATH clause in SQL Server blog
Article
FOR XML PATH clause in SQL Server 
By Yash Vardhan Gupta
Updated on: Feb 03, 2026
Explicit Join vs Implicit Join in SQL Category Image
Article
Explicit Join vs Implicit Join in SQL
By Yash Vardhan Gupta
Updated on: Feb 02, 2026
Dynamic Table Name as a Variable in SQL Server Category Image
Article
Dynamic Table Name as a Variable in SQL Server
By Yash Vardhan Gupta
Updated on: Feb 02, 2026
Display names of All constraints for a table in Oracle SQL Small
Article
Display names of All constraints for a table in Or...
By Yash Vardhan Gupta
Updated on: Feb 02, 2026
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: Feb 02, 2026
feature 34
Article
DateTime format to SQL format using C#
By Yash Vardhan Gupta
Updated on: Feb 02, 2026
Feature 15
Article
Count(*) vs Count(1) in SQL Server
By Yash Vardhan Gupta
Updated on: Feb 02, 2026
Convert timestamps with offset to datetime obj using strptime Category Image
Article
Convert timestamps with offset to datetime obj usi...
By Yash Vardhan Gupta
Updated on: Feb 02, 2026
concat functions in sql server blog
Article
CONCAT() Function in SQL Server
By Yash Vardhan Gupta
Updated on: Feb 02, 2026
Can We Pass Parameters to a View in SQL Category Image
Article
Can We Pass Parameters to a View in SQL?
By Yash Vardhan Gupta
Updated on: Feb 02, 2026

Tutorials (5)

Interview Questions (13)

Webinars (0)