Search
 
SCRIPT & CODE EXAMPLE
 

SQL

mysql max

SELECT MIN(salary), MAX(salary) FROM employees;
SELECT team, MIN(salary), MAX(salary) FROM employees GROUP BY team;
Comment

mysql max()

USE world;
SELECT MAX(Population) AS 'Maximum Value'
FROM City
WHERE CountryCode = 'THA';
Comment

max mysql

//returns the maximum (highest) value
SELECT MAX(working_hours) AS Maximum_working_hours FROM employee;   
Comment

PREVIOUS NEXT
Code Example
Sql :: how to completely uninstall sql server 
Sql :: mysql join column order By and group By 
Sql :: keep getting an error when I try to connect to mysql workbench 
Sql :: create column that already exists mysql 
Sql :: postgres sql alter table delete row 
Sql :: Truncate a table then insert data 
Sql :: not equal in mysql query 
Sql :: oracle sql get value from several rows and concatenate strings 
Sql :: difference between left outer join and left join in sql 
Sql :: between keyword sql 
Sql :: how to put 0 or 000 depending IDCustomer length in sql server 
Sql :: Order of execution SQL or MySql query Or Logical order of operations: 
Sql :: create a database mysql 
Sql :: mysql allow connection from any host 
Sql :: normalization in sql 
Sql :: sql cross apply vs join 
Sql :: sql lowest number possible 
Sql :: test database for sql 
Sql :: sql change primary key to composite key 
Sql :: sql case sttement with set 
Sql :: Deleting data from tables 
Sql :: mysql run file command 
Sql :: store date time in mysql 
Sql :: stuff in sql 
Sql :: mysql split explode 
Sql :: Create table if not exist with exceptions 
Sql :: oracle exchange subpartition 
Sql :: System.Diagnostics.Process is not supported on this platform 
Sql :: ORACLE: How to get all column with GROUP by only 1 column? 
Sql :: mssql + bit + in python orm 
ADD CONTENT
Topic
Content
Source link
Name
2+7 =