Untitled
unknown
plain_text
a year ago
1.3 kB
18
Indexable
Limit:- select * from Customers where country ='UK' limit 1; select * from Customers where country ='UK' order by customer_id desc limit 1; offset:- syntax:-select * from table_name limit offset, rownumber; select * from Customers limit 3, 2; select * from Customers order by first_name limit 3, 2; for insert multiple value: insert into Customers values(6,"John","Doe",45, "USA"), (7, "Robert", "Luna", 22, "USA"); Agreagate function:- count() min() max() sum() avg() 1 . count: select distinct count(*) from Customers ; select distinct count(*) from Customers where first_name="John"; select distinct count(age) from Customers ; select count(*) as count from Customers ; max:-max fuction is used in all columns(numeric + string) string: max function is works on asschi value of character. select max(first_name) from Customers; min :- select min(first_name) from Customers; select min(first_name) from Customers where age=22; sum():used in only numeric column select sum(amount) as sum from Orders select sum(amount) as sum from Orders where amount>300; avg():-used only numeric column select avg(amount) as sum from Orders; select avg(amount) as sum from Orders where amount>300;
Editor is loading...
Leave a Comment