Click here to Skip to main content
15,790,917 members
Home / Discussions / Database
   

Database

 
AnswerRe: ORDER BY in UNION Pin
jschell29-May-23 7:15
jschell29-May-23 7:15 
GeneralRe: ORDER BY in UNION Pin
_Flaviu29-May-23 8:54
_Flaviu29-May-23 8:54 
AnswerRe: ORDER BY in UNION Pin
Richard Deeming29-May-23 22:37
mveRichard Deeming29-May-23 22:37 
AnswerRe: ORDER BY in UNION Pin
Richard Andrew x6431-May-23 3:41
professionalRichard Andrew x6431-May-23 3:41 
GeneralRe: ORDER BY in UNION Pin
_Flaviu13-Jun-23 9:28
_Flaviu13-Jun-23 9:28 
AnswerRe: ORDER BY in UNION Pin
Richard Andrew x6413-Jun-23 14:19
professionalRichard Andrew x6413-Jun-23 14:19 
GeneralRe: ORDER BY in UNION Pin
_Flaviu14-Jun-23 10:29
_Flaviu14-Jun-23 10:29 
GeneralRe: ORDER BY in UNION Pin
Richard Andrew x6414-Jun-23 14:00
professionalRichard Andrew x6414-Jun-23 14:00 
Whoops! I guess that's why nobody else recommended that. I forgot that ORDER BY is not allowed in derived tables.

I think the temporary table is probably your best option.



The difficult we do right away...
...the impossible takes slightly longer.

AnswerHow about a Temp table Pin
David Mujica6-Jun-23 4:40
David Mujica6-Jun-23 4:40 
GeneralRe: How about a Temp table Pin
jschell6-Jun-23 5:59
jschell6-Jun-23 5:59 
GeneralRe: How about a Temp table Pin
k50546-Jun-23 6:24
mvek50546-Jun-23 6:24 
GeneralRe: How about a Temp table Pin
jschell7-Jun-23 6:09
jschell7-Jun-23 6:09 
QuestionEntityFramewok Core 6 WPF App Pin
Kevin Marois18-May-23 17:57
professionalKevin Marois18-May-23 17:57 
AnswerRe: EntityFramewok Core 6 WPF App Pin
Richard Deeming18-May-23 22:11
mveRichard Deeming18-May-23 22:11 
QuestionChoosing a proper database for mobile messenger app Pin
Alex Dunlop17-Apr-23 6:53
Alex Dunlop17-Apr-23 6:53 
AnswerRe: Choosing a proper database for mobile messenger app Pin
jschell17-Apr-23 7:15
jschell17-Apr-23 7:15 
GeneralRe: Choosing a proper database for mobile messenger app Pin
Alex Dunlop17-Apr-23 7:24
Alex Dunlop17-Apr-23 7:24 
GeneralRe: Choosing a proper database for mobile messenger app Pin
Mycroft Holmes17-Apr-23 13:48
professionalMycroft Holmes17-Apr-23 13:48 
GeneralRe: Choosing a proper database for mobile messenger app Pin
jschell18-Apr-23 5:58
jschell18-Apr-23 5:58 
AnswerRe: Choosing a proper database for mobile messenger app Pin
Eddy Vluggen18-Apr-23 0:27
professionalEddy Vluggen18-Apr-23 0:27 
GeneralRe: Choosing a proper database for mobile messenger app Pin
jschell18-Apr-23 6:00
jschell18-Apr-23 6:00 
AnswerRe: Choosing a proper database for mobile messenger app Pin
Richard MacCutchan18-Apr-23 0:56
mveRichard MacCutchan18-Apr-23 0:56 
GeneralRe: Choosing a proper database for mobile messenger app Pin
Code4Ever18-Apr-23 1:03
Code4Ever18-Apr-23 1:03 
GeneralRe: Choosing a proper database for mobile messenger app Pin
Richard MacCutchan18-Apr-23 1:29
mveRichard MacCutchan18-Apr-23 1:29 
GeneralRe: Choosing a proper database for mobile messenger app Pin
jschell18-Apr-23 6:15
jschell18-Apr-23 6:15 

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.