How to use order by in SQL | Sorting data in SQL

Details

Description

Whatsapp Number : +919212535516
Email id :- luthra.anjali@gmail.com
Playlist for Complete Course for Informatics Practices
https://www.youtube.com/playlist?list=PLDDXuRcB-QG7zubiLLoWwkevc6tLsDdq9
Playlist for Complete Course for Computer Science https://www.youtube.com/playlist?list=PLDDXuRcB-QG7lL1hRX5TdC8UQEJNp1bdi


Fetching Sorted data from SQL Table

Order by Clause

select */attributes from tablename
where condition order by attributename asc/desc;

select * from student order by admno;

select name, marks from student
where class='xii' order by marks desc;

display the details of employees working in deptno in increasing order of their salary
select * from employee where deptno=10
order by salary;

select * from employee where deptno=10
order by salary desc, ename ;

-to display the name and salary of all employees working as manager in decreasing order of salary
-arrange the employees in increasing order as per their deptno and employees in same department should be displayed in increasing order of their empid.

Facebook Page :
https://www.facebook.com/aeccomputereducation/
Link for Complete Java Tutorial in HIndi https://www.youtube.com/playlist?list=PLDDXuRcB-QG6MQ1Lwh4fI1cvNb09k0dOn
Link for Complete Tutorial for Programming in C in HIndi https://www.youtube.com/playlist?list=PLDDXuRcB-QG5br_VxN4zSmORIKJSfh1Rj

Link for Complete Python Tutorial in HIndi https://www.youtube.com/playlist?list=PLDDXuRcB-QG7FAWqrgUms1xEf7CcD7mjq

Complete Study Material for Class 12 CS https://www.youtube.com/playlist?list=PLDDXuRcB-QG4UDvkbqPV2y0La-PptDect

Complete Study Material for Class 12 IP https://www.youtube.com/playlist?list=PLDDXuRcB-QG7gfmbcp-hJF5AeKd82-fz6