MIN()
SELECT MIN(Price) AS SmallestPrice
FROM regtable;
MAX()
SELECT MAX(Price) AS LargestPrice
FROM regtable;
COUNT()
SELECT COUNT(username)
FROM regtable;
AVG()
SELECT AVG(Price)
FROM regtable;
SUM()
SELECT SUM(Quantity)
FROM regtable;
TOP
SELECT TOP 3 * FROM Customers;
LIMIT
SELECT * FROM Customers
LIMIT 3;
PERCENT
SELECT TOP 50 PERCENT * FROM Customers;
TOP with WHERE
SELECT TOP 3 * FROM regtable
WHERE Country=’INDIA’;
LIMIT with WHERE
SELECT * FROM Customers
WHERE Country=’Germany’
LIMIT 3;