ORDER BY Syntax for SELECT Query in MySQL

ORDER BY Syntax in Select Query can be used to arrange the data in Ascending or Descending order.

Example Table : For your reference

table_name

Column_name1	Column_name2	Column_name3	Column_name4
1	Male	articles	Sam
2	Female	database	Sam
3	Male	coding	Jam
4	Male	coding	Kam
5	Female	coding	Jam

Table Name is : table_name

ASCENDING ORDER

Query : "SELECT * from table_name ORDER BY Column_name3"

Query : "SELECT * from table_name ORDER BY Column_name3 ASC"

If you execute the above query then Column_name3 data will be sorted in ascending order

table_name

Column_name1	Column_name2	Column_name3	Column_name4
1	Male	articles	Sam
3	Male	coding	Jam
4	Male	coding	Kam
5	Female	coding	Jam
2	Female	Database	Sam

DESCENDING ORDER

Query : "SELECT * from table_name ORDER BY Column_name3 DESC"

If you execute the above query then Column_name3 data will be sorted in descending order

table_name

Column_name1	Column_name2	Column_name3	Column_name4
2	Female	Database	Sam
5	Female	coding	Jam
4	Male	coding	Kam
3	Male	coding	Jam
1	Male	articles	Sam

Comments

Gradle project sync failed. Basic functionality (e.g, editing, debugging) will not work properly.

Gradle is an open source build tool which help us to accelerate developer productivity. Go to Gradle Services website(http://services.gradle.org/distributions/) and download the latest version Download the latest version gradle-4.7-rc-1-all.zip ( Latest version while writing this article) and you can download greater than 4.7 if available and make sure the zip file contains "all" keyword (gradle-*.*-rc-*-all.zip). Go to your download location and unzip the downloaded file Android Studio > File > Settings > Build, Execution, Deployment Gradle Project-level settings -> Select Use local gradle distribution -> Select the unzip folder of downloaded gradle version -> Click OK button to exit from the Settings window. Please Wait until Gradle build completes and your problem have been resolved. If gradle build failed, follow few more steps to get resolved Final step to resolve this error Go to your project -> Gradle script -...

How to Send Secured Data in Internet - Steganography

Image Description: Hackers Growth of Science and Technology finds innovative ways to find patches over attacks made by hacker.In the Internet there are millions of computer are interconnected by network.If some people want to share some personal things like bank accounts or premium login accounts through email or any other share media but hacker who is surfing anonymously in the Internet find the personal documents and trying to modify the original message as well utilizing the original message so that the receiver who receive fake message from hacker thought that the message sended by sender.. In order to confuse hackers technology made another innovation in new technique called "Steganography" What is Steganography? Steganography is new technology innovation which hides text messages in image,audio,text and video files To Make your data very securely just what you need to do is find the best steganography software from Internet and download it and then encrypt your me...

Spring Boot GraphQL Save, Update and Delete - Database MutationMapping

Learn how to get started with Graphql using spring boot framework. In this session, you will be learning like how to add the schema details and mapping the function and request payload with Graphql @MutationMapping into your controller class. So you can preform like Save, update and delete operation using graphql You need Spring web, JPA, Mysql, Lombok and Spring Graphql dependencies to your pom module. schema.graphqls (This file should be created inside the resources/graphql folder) type Query{ findAll: [User] userById(id: ID): User } type User{ id: ID name: String gender: String emailId: String } type Mutation{ addUser(userDetails: UserDetails): User updateUser(userDetails: UserDetails): User deleteUser(id: ID): String } input UserDetails{ id: ID name: String gender: String emailId: String } UserGQLController .java package com.hakeemit.graphql.controller; import com.hakeemit.graphql.entity.User; import com.hakeemit.gra...

Technology Innovation

Search This Blog