Monday, 11 June 2018

ORDER BY

This is used to sort the record.

ASC - It sorts in ascending order (by default).
DESC - It sorts in descending order.

1. Sorts in descending order

Syntax :-

   SELECT * FROM table_name
   ORDER BY column_name DESC;

Example :-

   SELECT * FROMemp
   ORDER BY emp_name DESC;


 Example :-

Related Posts:

  • LIKE Operator The LIKE operator is used to search for a specified pattern in a column. Syntax :-     SELECT * FROM table_name     W… Read More
  • OR Operator The OR operator displays a record if either the first condition OR the second condition is true. Syntax :-   SELECT * FROM table_name   W… Read More
  • IN Operator The IN operator allows you to specify multiple values in a WHERE clause. Syntax :-    SELECT * FROM table_name    WHERE column_… Read More
  • AND Operator The AND operator display a records if both the first condition AND the second condition are true. Syntax :-      SELECT * FROM t… Read More
  • BETWEEN Number operator The BETWEEN operator selects values within a range. The values can be numbers, text, or dates. 1. Between Number Syntax :-    SELECT * F… Read More

0 Comments:

Post a Comment

Popular Posts

Categories

100 Python Programs for Beginner (96) AI (39) Android (24) AngularJS (1) Api (2) Assembly Language (2) aws (17) Azure (7) BI (10) book (4) Books (197) C (77) C# (12) C++ (83) Course (67) Coursera (249) Cybersecurity (25) Data Analysis (2) Data Analytics (2) data management (11) Data Science (148) Data Strucures (8) Deep Learning (21) Django (16) Downloads (3) edx (2) Engineering (14) Euron (29) Events (6) Excel (13) Factorial (1) Finance (6) flask (3) flutter (1) FPL (17) Generative AI (11) Google (36) Hadoop (3) HTML Quiz (1) HTML&CSS (47) IBM (30) IoT (1) IS (25) Java (93) Java quiz (1) Leet Code (4) Machine Learning (85) Meta (22) MICHIGAN (5) microsoft (4) Nvidia (4) Pandas (4) PHP (20) Projects (29) pyth (1) Python (1034) Python Coding Challenge (454) Python Quiz (113) Python Tips (5) Questions (2) R (70) React (6) Scripting (1) security (3) Selenium Webdriver (4) Software (17) SQL (42) UX Research (1) web application (8) Web development (4) web scraping (2)

Followers

Python Coding for Kids ( Free Demo for Everyone)