quote:

---

Originally posted by levinll

Am applying for a job and they have sent me test to complete. One of them requires SQL statement. I tried installing mySQL for my windows machine, but the service keeps shutting down so I can't create/test any code. Therefore I'm looking for any/all help in answering this question.

here's the question:
8. Given the below SQL Server table definitions, write a SQL statement that will retrieve a list of all unique resultId values for a patient with an accountNumber of “M000001234”.

CREATE TABLE [dbo].[Patients](
[id] [int] IDENTITY(1,1) NOT NULL,
[lastName] [varchar](50) NOT NULL,
[firstName] [varchar](50) NOT NULL,
[accountNumber] [varchar](50) NOT NULL,
CONSTRAINT [PK_Patients] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[PatientResults](
[patientId] [int] NOT NULL,
[resultId] [varchar](25) NOT NULL,
[resultDateTime] [datetime] NOT NULL,
[result] [varchar](100) NOT NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[PatientResults] WITH CHECK ADD CONSTRAINT [FK_PatientResults_Patients] FOREIGN KEY([patientId])
REFERENCES [dbo].[Patients] ([id])
GO
ALTER TABLE [dbo].[PatientResults] CHECK CONSTRAINT [FK_PatientResults_Patients]
GO


Thanks to all who help me answer/solve my problem so I can't get this job.

---

quote:

---

Originally posted by levinll


Thanks to all who help me answer/solve my problem so I can't get this job.

---