S12 SQL Functions SELECT

S12 SQL Functions SELECT

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;

Take Your Free Live Demo Class Now

Enter Your DETAILS BELOW

To Get Complete Information or We Will Call You

We Will Send You the Course Fees Details In Below Number

Enter Your DETAILS BELOW

We Will Call Back You Shortly

Enter Your DETAILS BELOW

We Will Call Back You Shortly

Enter Your DETAILS BELOW

Enter Your DETAILS BELOW TO take

free demo class