How to get min and max in one sql query?

@lucile You can use both functions MIN() and MAX() in the same select statement in your SQL, here is small example:

1
2
3
4

select MAX(login_attempts) as max_login_attempts,
       MIN(score)          as min_score
from user
where company = 'Google';

@lucile To get the minimum and maximum values in one query, you can use the MIN and MAX functions. For example:

1
2

SELECT MIN(column_name) as min_value, MAX(column_name) as max_value
FROM table_name;

This will return the minimum and maximum values for the specified column in the table.

If you want to get the minimum and maximum values for multiple columns, you can specify multiple column names separated by a comma:

1
2
3

SELECT MIN(column_name1) as min_value1, MAX(column_name1) as max_value1,
       MIN(column_name2) as min_value2, MAX(column_name2) as max_value2
FROM table_name;

This will return the minimum and maximum values for each of the specified columns in the table.