MIN() && MAX() in SQL: Did You Know?!
In this sql tutorial we'll walk you through the sql functions min() and max(). We'll also explain that these sql functions can be used on string values, which is something you probably didn't even know!
When used on string values within a SQL database, both the MIN() and MAX() SQL functions will take the SQL database collation into account.
Basic rules state that A is less than B && q is more than w. These kinds of SQL functions "weigh" strings against these rules.
One can also specify the database collation of a specific SQL column within the function:
SELECT MAX(c1 COLLATE greek_general_ci);
Do subscribe to this database tutorial and sql tutorial channel for more sql interview questions and answers based on mysql server and other database management systems!
Music:
Boost by Peyruis: / peyruis
Creative Commons — Attribution 3.0 Unported — CC BY 3.0
Free to Download / Stream.
Music promoted by Audio Library: • Boost – Peyruis (No Copyright Music)
#shorts #reels #web #database #mysql #sql #interview #interviews