6 Sorting Data with ORDER BY - A Funny Take with Amit Bhadana Characters Part 2
Suppose we have a table named "amit_bhadana_characters" with the following columns: "name", "age", and "catchphrase". Here are some sample rows: name age catchphrase Amit Bhadana 27 "Aalas Hatao, Life Banao" Babloo bhaiya 35 "Babloo Bhaiya ka style" Sameer bhaiya 30 "Kya bolte bantai" Genda bhaiya 40 "Hum Genda bhaiya hai" Now let's say we want to sort this table based on the "age" column in ascending order. We would use the following SQL statement:Copy code SELECT * FROM amit_bhadana_characters ORDER BY age ASC ; This would give us the following result: name age catchphrase Amit Bhadana 27 "Aalas Hatao, Life Banao" Sameer bhaiya 30 "Kya bolte bantai" Babloo bhaiya 35 "Babloo Bhaiya ka style" Genda bhaiya 40 "Hum Genda bhaiya hai" Similarly, if we want to sort in descending order, we would use the following SQL statement: SELECT * FROM amit_bhada