Click here to Skip to main content
15,610,223 members
Home / Discussions / Database
   

Database

 
QuestionGiven two dates, count the number of dates in the range that is within month X Pin
Jame_T13-Apr-22 3:43
Jame_T13-Apr-22 3:43 
AnswerRe: Given two dates, count the number of dates in the range that is within month X Pin
Craig Robbins13-Apr-22 4:10
Craig Robbins13-Apr-22 4:10 
AnswerRe: Given two dates, count the number of dates in the range that is within month X Pin
CHill6020-Apr-22 7:04
mveCHill6020-Apr-22 7:04 
QuestionBest practice for creating a limited access ms-sql user ? Pin
David Mujica12-Apr-22 11:12
David Mujica12-Apr-22 11:12 
AnswerRe: Best practice for creating a limited access ms-sql user ? Pin
jschell8-May-22 8:11
jschell8-May-22 8:11 
QuestionMysql How to sort row ORDER BY another query? Pin
Zac Ang3-Apr-22 10:45
Zac Ang3-Apr-22 10:45 
SuggestionRe: Mysql How to sort row ORDER BY another query? Pin
Richard Deeming3-Apr-22 21:46
mveRichard Deeming3-Apr-22 21:46 
AnswerRe: Mysql How to sort row ORDER BY another query? Pin
CHill606-Apr-22 2:57
mveCHill606-Apr-22 2:57 
Firstly - take note of the previous comment about SQL Injection!

Quote:
I want the array `$user_tree` to hold (user_id 5) first, then (user_id 6), how to do that?
Then you need to order your results by [user_id] e.g.
SQL
select * 
from @demo
where upline = 2
order by [User_id];
Quote:
I want to print **Left_id** first, then only print **Right_id**. May I know how to do it?
I'm not entirely sure what you mean here, but it sounds like you want the columns in a different order in your result. In the example above I used select * - that is not actually good practice. It is much better to list the columns that you want, in the order that you want them - this helps protect any code that is using the results from any subsequent changes to the table schema, such as adding a new column.

However, if you mean you want to sort by one column within the "grouping" of another column then you simply add a list of things to sort by.

This example covers both the scenarios above
SQL
select Left_id,Right_id
from @demo 
order by Upline, [User_id];
If you meant something else then reply to this solution and I will try to help
QuestionFilter data before lookup(join) two collections in mongodb Pin
85510-Mar-22 4:20
85510-Mar-22 4:20 
Rant[REPOST] Filter data before lookup(join) two collections in mongodb Pin
Richard Deeming10-Mar-22 4:51
mveRichard Deeming10-Mar-22 4:51 
GeneralRe: [REPOST] Filter data before lookup(join) two collections in mongodb Pin
85510-Mar-22 5:23
85510-Mar-22 5:23 
GeneralRe: [REPOST] Filter data before lookup(join) two collections in mongodb Pin
Richard Deeming10-Mar-22 6:26
mveRichard Deeming10-Mar-22 6:26 
Question[MySQL] Failed to set datadir Pin
chipp_zanuff1-Mar-22 7:54
chipp_zanuff1-Mar-22 7:54 
AnswerRe: [MySQL] Failed to set datadir Pin
Victor Nijegorodov1-Mar-22 8:39
Victor Nijegorodov1-Mar-22 8:39 
GeneralRe: [MySQL] Failed to set datadir Pin
chipp_zanuff1-Mar-22 17:42
chipp_zanuff1-Mar-22 17:42 
GeneralRe: [MySQL] Failed to set datadir Pin
Victor Nijegorodov1-Mar-22 22:42
Victor Nijegorodov1-Mar-22 22:42 
AnswerRe: [MySQL] Failed to set datadir Pin
Richard MacCutchan1-Mar-22 22:45
mveRichard MacCutchan1-Mar-22 22:45 
GeneralRe: [MySQL] Failed to set datadir Pin
chipp_zanuff2-Mar-22 0:35
chipp_zanuff2-Mar-22 0:35 
GeneralRe: [MySQL] Failed to set datadir Pin
Richard MacCutchan2-Mar-22 0:47
mveRichard MacCutchan2-Mar-22 0:47 
GeneralRe: [MySQL] Failed to set datadir Pin
chipp_zanuff2-Mar-22 23:37
chipp_zanuff2-Mar-22 23:37 
GeneralRe: [MySQL] Failed to set datadir Pin
Richard MacCutchan2-Mar-22 23:44
mveRichard MacCutchan2-Mar-22 23:44 
GeneralRe: [MySQL] Failed to set datadir Pin
chipp_zanuff3-Mar-22 0:30
chipp_zanuff3-Mar-22 0:30 
GeneralRe: [MySQL] Failed to set datadir Pin
Richard MacCutchan3-Mar-22 0:46
mveRichard MacCutchan3-Mar-22 0:46 
QuestionDetach database in SQL Server Pin
Meysam Toluie17-Feb-22 4:44
Meysam Toluie17-Feb-22 4:44 
QuestionWorks in MYSQL 5.7, Syntax Error in MYSQL 8.0 Pin
Douglas Kirk 202216-Feb-22 2:36
Douglas Kirk 202216-Feb-22 2:36 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.