Click here to Skip to main content
16,016,076 members
Home / Discussions / Database
   

Database

 
AnswerRe: Multi-user use the database at the same time Pin
Dave Kreskowiak14-Aug-23 5:12
mveDave Kreskowiak14-Aug-23 5:12 
AnswerRe: Multi-user use the database at the same time Pin
jschell14-Aug-23 6:37
jschell14-Aug-23 6:37 
QuestionTough one Pin
Richard Andrew x6431-Jul-23 4:59
professionalRichard Andrew x6431-Jul-23 4:59 
AnswerRe: Tough one Pin
Richard Deeming31-Jul-23 5:33
mveRichard Deeming31-Jul-23 5:33 
GeneralRe: Tough one Pin
Richard Andrew x6431-Jul-23 5:35
professionalRichard Andrew x6431-Jul-23 5:35 
QuestionWhy do some websites provide Demo for their premium html themes while the codes can be seen using inspection tool in chrome? Pin
Alex Dunlop11-Jul-23 6:30
Alex Dunlop11-Jul-23 6:30 
AnswerRe: Why do some websites provide Demo for their premium html themes while the codes can be seen using inspection tool in chrome? Pin
PIEBALDconsult11-Jul-23 6:01
mvePIEBALDconsult11-Jul-23 6:01 
QuestionORDER BY in UNION Pin
_Flaviu29-May-23 5:14
_Flaviu29-May-23 5:14 
Is there possible to get an UNION in such a way that second part of UNION to be ordered ?

I have:
SQL
SELECT column_name(s) FROM table1
UNION
SELECT column_name(s) FROM table2 ORDER BY 3

The select from table1 will always get one row, and I need to order just records that come from table2, which could be more than one row ... it is possible to achieve that by SQL ?

P.S. I am using SQL Server.

modified 29-May-23 13:54pm.

AnswerRe: ORDER BY in UNION Pin
jschell29-May-23 6:15
jschell29-May-23 6:15 
GeneralRe: ORDER BY in UNION Pin
_Flaviu29-May-23 7:54
_Flaviu29-May-23 7:54 
AnswerRe: ORDER BY in UNION Pin
Richard Deeming29-May-23 21:37
mveRichard Deeming29-May-23 21:37 
AnswerRe: ORDER BY in UNION Pin
Richard Andrew x6431-May-23 2:41
professionalRichard Andrew x6431-May-23 2:41 
GeneralRe: ORDER BY in UNION Pin
_Flaviu13-Jun-23 8:28
_Flaviu13-Jun-23 8:28 
AnswerRe: ORDER BY in UNION Pin
Richard Andrew x6413-Jun-23 13:19
professionalRichard Andrew x6413-Jun-23 13:19 
GeneralRe: ORDER BY in UNION Pin
_Flaviu14-Jun-23 9:29
_Flaviu14-Jun-23 9:29 
GeneralRe: ORDER BY in UNION Pin
Richard Andrew x6414-Jun-23 13:00
professionalRichard Andrew x6414-Jun-23 13:00 
AnswerHow about a Temp table Pin
David Mujica6-Jun-23 3:40
David Mujica6-Jun-23 3:40 
GeneralRe: How about a Temp table Pin
jschell6-Jun-23 4:59
jschell6-Jun-23 4:59 
GeneralRe: How about a Temp table Pin
k50546-Jun-23 5:24
mvek50546-Jun-23 5:24 
GeneralRe: How about a Temp table Pin
jschell7-Jun-23 5:09
jschell7-Jun-23 5:09 
QuestionEntityFramewok Core 6 WPF App Pin
Kevin Marois18-May-23 16:57
professionalKevin Marois18-May-23 16:57 
AnswerRe: EntityFramewok Core 6 WPF App Pin
Richard Deeming18-May-23 21:11
mveRichard Deeming18-May-23 21:11 
QuestionChoosing a proper database for mobile messenger app Pin
Alex Dunlop17-Apr-23 5:53
Alex Dunlop17-Apr-23 5:53 
AnswerRe: Choosing a proper database for mobile messenger app Pin
jschell17-Apr-23 6:15
jschell17-Apr-23 6:15 
GeneralRe: Choosing a proper database for mobile messenger app Pin
Alex Dunlop17-Apr-23 6:24
Alex Dunlop17-Apr-23 6:24 

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.