Similar Topics

Web Technologies32.1K+ articles

Databases2.0K+ articles

SQL1.4K+ articles

DBMS-SQL531+ articles

mysql350+ articles

SQL-Server319+ articles

SQL-Query194+ articles

SQL-basics38+ articles

DBMS Indexing12+ articles

sql-operators6+ articles

SQLmysql

50 posts

Last Updated: 27 August 2025

CROSS JOIN in SQL generates the Cartesian product of two tables, meaning each row from the first table is paired with every row from the second. This is useful when you wa...read more

article_image

Last Updated: 27 August 2025

A Self Join is a regular join where a table is joined with itself. It is particularly useful when comparing rows within the same table, such as retrieving employee-manager...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: 26 August 2025

HAVING clause filters results after applying aggregate functions. Unlike WHERE, which filters individual rows, HAVING works with aggregated results.Its main features inclu...read more

Multiple Joins in SQL

Last Updated: 27 August 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: 27 August 2025

Outer Joins allow retrieval of rows from two or more tables based on a related column. Unlike Inner Joins, Outer Joins also include rows that do not have a corresponding m...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: 28 August 2025

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

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