Similar Topics

Web Technologies32.1K+ articles

DSA20.4K+ articles

Misc7.7K+ articles

Databases1.9K+ articles

SQL1.4K+ articles

DBMS-SQL531+ articles

mysql355+ articles

Oracle354+ articles

SQL-Query196+ articles

SQLmysql50+ articles

SQL-Functions

26 posts

Working with Dates in SQL

Last Updated: 13 February 2026

SQL provides built-in date functions to extract and manipulate parts of a date value. These functions help analyze and organize time-based data efficiently.Functions like ...read more

article_image

Difference Between WHERE FIND_IN_SET(…)>0 and WHERE FIND_IN_SET(…) in SQL

Last Updated: 23 July 2025

FIND_IN_SET(...): This function returns the index(starting from 1) of the required string in a given list of strings if it is present in the list. If the required string i...read more

article_image

Difference Between

WIDTH_BUCKET( ) Function in Oracle

Last Updated: 09 November 2021

WIDTH_BUCKET( ) is a mathematical function used in Oracle and PostgreSQL. As the name suggests width_bucket means dividing the histogram into equal width buckets, that is ...read more

SQL Query to Alter Column Size in MySQL

Last Updated: 23 July 2025

In MySQL, managing the structure of a database is crucial for optimal data organization and integrity. One common task is altering the size of a column to accommodate chan...read more

SQL - SELECT SUM

Last Updated: 23 July 2025

In SQL, the SELECT SUM statement is used to calculate the total sum of values in a numeric column. This powerful aggregate function allows you to summarize large sets of d...read more

article_image

Last Updated: 14 March 2023

Any SQL query is not fundamentally related to performance, but when used in large fields and its amount is expected to be very large, the performance issue is always prese...read more

article_image

SQL ALTERNATE KEY

Last Updated: 11 April 2026

An Alternate Key is a candidate key that is not chosen as the Primary Key but can still uniquely identify a record in a table.When multiple attributes can uniquely identif...read more

article_image

SQL - SELECT RANDOM

Last Updated: 23 July 2025

In SQL, the RANDOM() function is used to fetch random rows from a table. It is an extremely useful function in various applications, such as selecting random users, retrie...read more

article_image

SQL SELECT FIRST

Last Updated: 23 July 2025

The SELECT FIRST clause is used in some SQL databases (primarily MS Access) to retrieve the first record from a table based on the order in which data is stored or queried...read more

article_image

SQL - SELECT LAST

Last Updated: 23 July 2025

SELECT LAST is a concept or function often used to describe retrieving the last record or last row from a table in SQL. Although MS Access supports a LAST() function to di...read more

article_image

SQL | ENCRYPT Function

Last Updated: 31 October 2019

The SQL Encrypt function is used to encrypt a string using UNIX crypt(). The function is based on Unix crypt() system call, hence it returns NULL on Windows systems. The E...read more

Categories of SQL Functions

Last Updated: 05 December 2025

SQL functions are powerful tools that help streamline queries, perform operations, and manipulate data efficiently. They are essential for handling various tasks within SQ...read more

MySQL | Group_CONCAT() Function

Last Updated: 11 July 2025

The GROUP_CONCAT() function in MySQL is an aggregation function that combines data from multiple rows into a single string. It is particularly useful for aggregating summa...read more

MySQL | LEAD() and LAG() Function

Last Updated: 11 July 2025

The LEAD() and LAG() functions in MySQL are powerful window functions introduced in version 8.0. They allow users to access data from preceding or following rows without t...read more

SQL | Advanced Functions

Last Updated: 08 September 2025

SQL provides a variety of advanced functions for performing complex calculations, transformations and aggregations on data. These functions are essential for data analysis...read more

article_image

1 2