Table column sorting based on NULL Value

Theva Deva

I want to sort column2 based on Column1 values. I want split column1 data based on NULL value. The final query result will be displayed on evaluating the values in the column1

   Column1    Column2 
    NULL         100
    NULL          60
    NULL          90
    10            22
    20            40
    05            35
    15            20
    40            10
    30            25
    20            30

Would become:

   Column1     Column2 
    20            40
    05            35
    20            30
    30            25
    10            22
    15            20
    40            10
    NULL         100
    NULL          90
    NULL          60

Thanks

Gurwinder Singh

You can use case in your order by clause like this:

Select * from t
Order by case when column1 is null then 1 else 0 end, column2 desc

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2020-10-26

Comments

0 comments

Eloquent sorting based on column value

Pandas: Sorting rows based on a value of a column

Sorting mat-table by column value

Lexicographical sorting of a Postgres table column based on values of another column

How to fill a NULL in a column with the value of a different line based on same id of a different table

Sorting table rows based on column class names using pure Javascript

Sorting the rows based on a particular column value using groovy

Linq filter based on null column value

Create a constraint based on column value to ensure not null

Sorting a list based on the average value of field under associated table

create table column based on another table column value in sql

Join table based on column value in SQL Server

Query table based on the value of another tables column

Expand table rows based on column value

Date Diff in the same column, based on the value of the table

Group items in a table based on value in column and count

Color table row based on column value

Return column headers based on value in table

change value in a column of a table based on a reference

Inner Join table based on column value

Extricating table based on the first unique column value

Insert rows into another table based on column value

Vuetify Table - rendering column value based on a condition

Get the value in the table that some column is null in MYSQL

Update Column value for all rows in Table where Column Value Is Null?

Sorting table rows by a column

Sorting array based on value

Sorting a group based on value

Problems in sorting a column by value

TOP Ranking

Article

Table column sorting based on NULL Value

Table column sorting based on NULL Value

Loopback Error: connect ECONNREFUSED 127.0.0.1:3306 (MAMP)

Can't pre-populate phone number and message body in SMS link on iPhones when SMS app is not running in the background

pump.io port in URL

How to import an asset in swift using Bundle.main.path() in a react-native native module

Failed to listen on localhost:8000 (reason: Cannot assign requested address)

Spring Boot JPA PostgreSQL Web App - Internal Authentication Error

Emulator wrong screen resolution in Android Studio 1.3

3D Touch Peek Swipe Like Mail

Double spacing in rmarkdown pdf

Svchost high CPU from Microsoft.BingWeather app errors

How to how increase/decrease compared to adjacent cell

Using Response.Redirect with Friendly URLS in ASP.NET

java.lang.NullPointerException: Cannot read the array length because "<local3>" is null

BigQuery - concatenate ignoring NULL

How to fix "pickle_module.load(f, **pickle_load_args) _pickle.UnpicklingError: invalid load key, '<'" using YOLOv3?

ngClass error (Can't bind ngClass since it isn't a known property of div) in Angular 11.0.3

Can a 32-bit antivirus program protect you from 64-bit threats

Make a B+ Tree concurrent thread safe

Bootstrap 5 Static Modal Still Closes when I Click Outside

Vector input in shiny R and then use it

Assembly definition can't resolve namespaces from external packages