Untitled

01/02/2024
_________________________________________________________________
order by clause:
order by clause is used for the data sort in ascending and descending order.

synatx:-
select columns from tablename order by column_name asc/desc;

select * from customer;
select * from customer order by cust_name asc;

select * from employeeinfo order by name desc ,address desc;

when we short data in any filter condition we use where and order by clause;
sequence is mandatory:
1 where
2.order by

select * from employeeinfo where salary>30000 order by name desc ;

-----------------------------------------------------------------------------------------------------

Limit clause:
limit clause is used for return specific number of records.

syntax:-select columns from tablename limit number;
select * from customer limit 6;
select cust_name,city from customer limit 3;

select * from employeeinfo where salary=30000;
select * from employeeinfo where salary=30000 limit 2;
select * from employeeinfo where salary=30000 order by name ,id limit 2;

Q2:
Display details of first 5 highly paid employees using MySQL
ans:-
select  * from  employee order by salary desc limit 5;