Sql

-- returns records where amount is greater than or equal to 400
SELECT order_id, item, amount
FROM Orders
WHERE amount >= 400;

select greatest(1,2,3,4,5);

SELECT *
FROM employees
WHERE employee_id >= 3000;

SELECT *
FROM Customers
WHERE age > 25;

Greater than :
SELECT * FROM employees WHERE employee_id >= 3000;

-- returns records where amount is greater than 400 (exclusive)
SELECT order_id, item, amount
FROM Orders
WHERE amount > 400;

-- returns records where amount is greater than or equal to 400
SELECT order_id, item, amount
FROM Orders
WHERE amount >= 400;

select greatest(1,2,3,4,5);

SELECT *
FROM employees
WHERE employee_id >= 3000;

SELECT *
FROM Customers
WHERE age > 25;

Greater than :
SELECT * FROM employees WHERE employee_id >= 3000;

-- returns records where amount is greater than 400 (exclusive)
SELECT order_id, item, amount
FROM Orders
WHERE amount > 400;

PREVIOUS	NEXT

Code Example
Sql :: sql datitime to date
Sql :: change column name mysql
Sql :: create table like another table
Sql :: insert in to table sql
Sql :: sql server current time without date
Sql :: add not null constraint sql server
Sql :: laravel eloquent get generated sql
Sql :: mysql random
Sql :: mysql locate
Sql :: oracle session statistics
Sql :: command to give readonly access to a postgres sql user
Sql :: psql generate id in existing database
Sql :: sql create table with data
Sql :: mysql community server
Sql :: sql ending with vowels
Sql :: postgres how to add field created at
Sql :: stuff sql server
Sql :: oracle enable chain
Sql :: select all tables linked server sql
Sql :: sql update
Sql :: oracle get ddl
Sql :: oracle show errors compilation
Sql :: mysql find db contarint
Sql :: rand mysql
Sql :: union all query in sql
Sql :: forcefully delete a row in mysql which has references
Sql :: postgres date
Sql :: how to get last inserted id in sql server c#
Sql :: select other columns with distinct
Sql :: Write SQL in ruby on rails