min plsql
--in query use MIN
SELECT MIN(something)
FROM some_table;
--in statements use LEAST (watch out, if there is a null it will return null)
local_variable := LEAST('2', '5', '12', '3');
--Here some examples
LEAST('2', '5', '12', '3')
Result: '12'
LEAST(2, 5, 12, 3)
Result: 2
LEAST('apples', 'applis', 'applas')
Result: 'applas'
LEAST('apples', 'applis', 'applas', null)
Result: NULL
Are there any code examples left?
New code examples in category SQL
-
SQL 2022-03-27 22:45:25 how to get mysql on ubuntu
-
SQL 2022-03-27 20:00:47 install latest mysql on debian 9
-
SQL 2022-03-27 19:45:11 sql '=' cannot be applied to date varchar(10) athena
-
SQL 2022-03-27 19:20:41 sql is not null
-
SQL 2022-03-27 19:20:39 sql group by error
-
SQL 2022-03-27 18:35:10 replace null with 0 in sql
-
SQL 2022-03-27 17:30:32 concat column value of same user in mysql
-
SQL 2022-03-27 17:05:02 sql developer sql worksheet not showing
-
SQL 2022-03-27 16:45:07 kill a pid redshift
-
SQL 2022-03-27 16:00:09 joins in sql server