Mysql Tutorial | Get Data With Specific Values On Top | Multi Values | Subquery

How to put specific values on the top in select query of mysql server.

Please avoid or flag spams/hateful comments. And do not spam. Enjoy :)

Subscribe my Channel:-
http://www.youtube.com/user/SanketRooney?sub_confirmation=1

Facebook Page:-
https://www.facebook.com/UnpossibleNS

Twitter Account:-
https://twitter.com/UnpossiblePOG

Blog :-
https://unpossiblepog.blogspot.in/

Hello guys.
This tutorial will be about how to give more priority to specific values in SELECT query of mysql database server without where clause. And how to fix the error “subquery returns more than 1 row”. In order by field. For example, what if you want employee should have more priority where the salary between 300 and 700 then the rest will be displayed.
The application of using this will be, getting data which are more related to topic like google search.
As you can see, i have one employee table, so instead of using where clause, I am going to use order by Field, the FIELD is a function, the first argument will be the calumn name that you want to be ordered, then in other arguments, you can specify which values you specifically want, in my case its steve and loki. Make sure to type “DESC” to make sure that they come on top of list.
But what if you don’t know how many data should have more priority or if the list is too large, in that case, we shall use the subquery.
In my case, I want to give prioritize by salary, so first argument will be salary, and in second argument, in subquery I am going to call primary key, which is ID, then apply the condition of salary between 300 and 800.
As you can see, it is giving me the error that “it is returning more than one row ” which is obvious. So to fix it, just apply condition “id in” before subquery.
In result, you can see that all the data is coming, but employee between salary 300 and 700 have more priority.
Thank you for watching, dont forget to like share and subscribe.