Similar Topics

Web Technologies32.1K+ articles

Databases1.9K+ articles

SQL1.4K+ articles

DBMS-SQL531+ articles

mysql355+ articles

MySQL290+ articles

SQL-Query196+ articles

SQL-basics38+ articles

DBMS Indexing12+ articles

sql-operators6+ articles

SQLmysql

50 posts

Last Updated: 21 November 2025

SQL CROSS JOIN creates a Cartesian product of two tables, meaning it returns every possible combination of rows from both tables. It does not use a join condition, and the...read more

article_image

Last Updated: 21 November 2025

SQL Self Join is used when a table needs to be joined with itself to compare rows within the same table. It helps in finding relationships between records in a single tabl...read more

article_image

How to Select the First Row of Each GROUP BY in SQL?

Last Updated: 23 July 2025

Selecting the first row of each group in SQL is a common requirement in database queries, especially when working with grouped data. SQL GROUP BY queries are highly effect...read more

article_image

Technical Scripter

Technical Scripter 2022

How to Convert Data From SQL to C Data Types?

Last Updated: 06 October 2022

At the point when an application calls SQLExecute or SQLExecDirect, the driver recovers the data for any boundaries bound with SQLBindParameter from capacity areas in the ...read more

SQL HAVING Clause

Last Updated: 09 February 2026

The SQL HAVING clause filters the results of grouped data after using the GROUP BY clause. It is used with aggregate functions such as SUM(), COUNT(), or AVG() to display ...read more

article_image

Multiple Joins in SQL

Last Updated: 14 November 2025

In SQL, multiple joins allow you to combine data from more than one table in a single query. This helps efficiently retrieve complex datasets without running multiple sepa...read more

article_image

Technical Scripter

SQL Full Outer Join Using Where Clause

Last Updated: 27 August 2025

A FULL OUTER JOIN is a type of SQL Join that returns all the rows from both tables (says Table 1 or Table 2), regardless of whether they have matching values. In short, we...read more

article_image

Last Updated: 14 April 2026

SQL provides the OUTER JOIN to return both matching and non-matching rows from two tables. It includes unmatched records by filling missing values with NULL. It returns ma...read more

article_image

SQL Natural Join

Last Updated: 27 August 2025

Natural Join is a type of join that automatically matches and combines rows from two tables based on columns with same name and compatible data types. Unlike other joins, ...read more

article_image

Last Updated: 08 September 2025

INNER JOIN is used to combine rows from two or more tables based on a related column. It returns only the rows that have matching values in both tables, filtering out non-...read more

article_image

Window Functions in SQL

Last Updated: 17 January 2026

SQL window functions allow performing calculations across a set of rows that are related to the current row, without collapsing the result into a single value. They are co...read more

article_image

Cloning Table in MySQL

Last Updated: 15 July 2025

Duplicating a table in MySQL involves creating a new table that replicates an existing table's structure and/or data. This capability is valuable for creating backups, set...read more

MySQLi Procedural Functions

Last Updated: 13 February 2023

MySQLi (MySQL Improved) provides procedural and object oriented interface to data and its management. The i extension MySQL functions allows the user to access its databas...read more

MySQL | CONNECTION_ID( ) Function

Last Updated: 25 November 2019

The MySQL CONNECTION_ID() function is used for return the connection ID for a current connection in MySQL. The connection ID used to establish a connection to a database i...read more

MySQL | CAST( ) Function

Last Updated: 12 May 2023

The MySQL CAST() function is used for converting a value from one datatype to another specific datatype. The CAST() function accepts two parameters which are the value to ...read more

article_image

1 2 3 4