SQL ORDER BY Key-word

SQL TUTORIALS-

SQL ORDER BY Key-word

Introduction-

ORDER BY keyword in SQL is used to sort the result set of a query by one or more columns. You can sort the data in ascending (ASC) or descending (DESC) order...

✅ 🔹 Syntax:

SELECT column1, column2, ...
FROM table_name
ORDER BY column1 [ASC | DESC], column2 [ASC | DESC], ...;

✅Result Show :-

🔸 Example Table: Employees

✅ Example:- Sort by Salary (Ascending):-

✅SELECT Query :-

SELECT * FROM Employees
ORDER BY Salary;

✅Result Show :-

🔸 Example Table: Employees

✅ Example -Sort by Name (Descending):-

✅SELECT Query :-

SELECT * FROM Employees
ORDER BY Name DESC;

✅Result Show :-

🔸 Example Table: Employees

May Be Like Important Link-

-Chart Of Account-OB13

-Define Plant-OX1

-Chart Of Account-OB13

-Define Financial Statement