Similar Topics

Web Technologies

37.6k+ articles

DSA

21.8k+ articles

Python

20k+ articles

How To

2.3k+ articles

C Language

1.7k+ articles

DBMS

1.4k+ articles

SQL

1.3k+ articles

mysql

310+ articles

SQL-Server

300+ articles

SQL-Functions

25 articles

SQLmysql

35 posts

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

Last Updated: 28 January 2023

The GROUP BY Statement in SQL is used to arrange identical data into groups with the help of some functions. To select the first row of each...read more

Technical Scripter

Technical Scripter 2022

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 par...read more

MySQL | COALESCE( ) Function

Last Updated: 21 November 2019

The MySQL COALESCE() function is used for returning the first non-null value in a list of expressions. If all the values in the list evaluat ...read more

Similar Topics

Web Technologies

37.6k+ articles

DSA

21.8k+ articles

Python

20k+ articles

How To

2.3k+ articles

C Language

1.7k+ articles

DBMS

1.4k+ articles

SQL

1.3k+ articles

mysql

310+ articles

SQL-Server

300+ articles

SQL-Functions

25+ articles

MySQL | IF( ) Function

Last Updated: 21 November 2019

The MySQL IF() function is used for validating a condition. The IF() function returns a value if the condition is TRUE and another value if ...read more

MySQL | CONVERT( ) Function

Last Updated: 19 November 2019

The MySQL CONVERT() function is used for converting a value from one datatype to a different datatype. The MySQL CONVERT() function is also ...read more

MySQL | ISNULL( ) Function

Last Updated: 19 November 2019

The MySQL ISNULL() function is used for checking whether an expression is NULL or not. This function returns 1 if the expression passed is N ...read more

MySQL | SHA1( ) Function

Last Updated: 17 February 2021

The MySQL SHA1() function is used for encrypting a string using the SHA-1 technique. The SHA1 stands for secure hash algorithm and it produc ...read more

MySQL | ENCODE( ) Function

Last Updated: 13 November 2019

The MySQL ENCODE() function is used for encoding a plain text string. The MySQL ENCODE() function returns a binary string which of the same ...read more

MySQL | DECODE( ) Function

Last Updated: 13 November 2019

The MySQL DECODE() function is used for decoding an encoded string and return the original string. The MySQL DECODE() function returns empty ...read more

MySQL | PASSWORD Function

Last Updated: 08 November 2019

The MySQL PASSWORD function is used for the generation of a hashed password using a plain-text password string It uses hashing techniques to ...read more

MySQL | MD5 Function

Last Updated: 08 November 2019

The MySQL MD5 function is used to return an MD5 128-bit checksum representation of a string. The MD5 message-digest algorithm is a widely us ...read more

MySQL | AES_DECRYPT ( ) Function

Last Updated: 14 September 2021

The MySQL AES_DECRYPT function returns the original string after decrypting an encrypted string. It uses AES(Advanced Encryption Standard) a ...read more

MySQL | AES_ENCRYPT ( ) Function

Last Updated: 25 August 2021

The MySQL AES_ENCRYPT function is used for encrypting a string using Advanced Encryption Standard (AES) algorithm. The MySQL AES_ENCRYPT fun ...read more

MySQL | Common MySQL Queries

Last Updated: 14 August 2021

MySQL server is a open-source relational database management system which is a major support for web based applications. Databases and relat...read more

Difference between MySQL and MS SQL Server

Last Updated: 30 January 2019

SQL is an acronym for Structured Query Language. It is used to access, manipulate and retrieve information from a database. MySQL is an open ...read more