MySQL Forums
Forum List  »  Quality Assurance

Re: Order by with group by, different results from different versions of mysql server
Posted by: mmtstraintimings.in ,
Date: September 04, 2011 08:45AM

it seems strange. I am going to test this on my production server.We are using mySQL for our local database needs for www.mmtstraintimings.in website.

CREATE TABLE [dbo].[glb_Schedules](
[ScheduleID] [bigint] IDENTITY(1,1) NOT NULL,
[ScheduleGroupID] [bigint] NULL,
[ScheduleTypeID] [int] NULL,
[StartTime] [smalldatetime] NULL,
[EndTime] [smalldatetime] NULL,

CONSTRAINT [PK_GLB_ScheduleDetails] PRIMARY KEY CLUSTERED
(
[ScheduleID] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

It is working as expected.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Order by with group by, different results from different versions of mysql server
1770
September 04, 2011 08:45AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.