Click here to Skip to main content
15,868,016 members
Home / Discussions / Database
   

Database

 
AnswerRe: Get a single record for each user Pin
Afzaal Ahmad Zeeshan25-Mar-15 23:17
professionalAfzaal Ahmad Zeeshan25-Mar-15 23:17 
GeneralRe: Get a single record for each user Pin
Meax25-Mar-15 23:30
Meax25-Mar-15 23:30 
GeneralRe: Get a single record for each user Pin
Afzaal Ahmad Zeeshan25-Mar-15 23:36
professionalAfzaal Ahmad Zeeshan25-Mar-15 23:36 
GeneralRe: Get a single record for each user Pin
Meax25-Mar-15 23:47
Meax25-Mar-15 23:47 
GeneralRe: Get a single record for each user Pin
RUs12326-Mar-15 0:42
RUs12326-Mar-15 0:42 
AnswerRe: Get a single record for each user Pin
Simon_Whale26-Mar-15 1:11
Simon_Whale26-Mar-15 1:11 
AnswerRe: Get a single record for each user Pin
Corporal Agarn26-Mar-15 1:16
professionalCorporal Agarn26-Mar-15 1:16 
AnswerRe: Get a single record for each user Pin
Member 1155935526-Mar-15 20:28
Member 1155935526-Mar-15 20:28 
SQL
SELECT d.ID, d.LogDate, d.Name, d.Department
FROM   DeviceLogs d, (SELECT MIN(LogDate) FROM DeviceLogs GROUP BY Name) s
WHERE  s.MIN(LogDate) = d.LogDate
ORDER BY d.LogDate;

SELECT ID, MIN(LogDate) AS LogDate, Name, Department
FROM yourtable
GROUP BY ID, Name, Department;

AnswerRe: Get a single record for each user Pin
Meax3-Apr-15 23:15
Meax3-Apr-15 23:15 
QuestionReason for failing to Drop Column is showing non existent Index Pin
indian14325-Mar-15 8:46
indian14325-Mar-15 8:46 
QuestionSql server 2008 R2 Express Edition working very slow why? Pin
Sandeep Tripathi25-Mar-15 0:44
Sandeep Tripathi25-Mar-15 0:44 
QuestionRe: Sql server 2008 R2 Express Edition working very slow why? Pin
Eddy Vluggen25-Mar-15 1:00
professionalEddy Vluggen25-Mar-15 1:00 
AnswerRe: Sql server 2008 R2 Express Edition working very slow why? Pin
Sandeep Tripathi25-Mar-15 1:10
Sandeep Tripathi25-Mar-15 1:10 
GeneralRe: Sql server 2008 R2 Express Edition working very slow why? Pin
Eddy Vluggen25-Mar-15 1:28
professionalEddy Vluggen25-Mar-15 1:28 
GeneralRe: Sql server 2008 R2 Express Edition working very slow why? Pin
Sandeep Tripathi25-Mar-15 1:31
Sandeep Tripathi25-Mar-15 1:31 
GeneralRe: Sql server 2008 R2 Express Edition working very slow why? Pin
Krishna Murthy G25-Mar-15 1:40
professionalKrishna Murthy G25-Mar-15 1:40 
GeneralRe: Sql server 2008 R2 Express Edition working very slow why? Pin
Sandeep Tripathi25-Mar-15 1:46
Sandeep Tripathi25-Mar-15 1:46 
GeneralRe: Sql server 2008 R2 Express Edition working very slow why? Pin
Eddy Vluggen25-Mar-15 2:04
professionalEddy Vluggen25-Mar-15 2:04 
AnswerRe: Sql server 2008 R2 Express Edition working very slow why? Pin
Tim Carmichael25-Mar-15 2:01
Tim Carmichael25-Mar-15 2:01 
GeneralRe: Sql server 2008 R2 Express Edition working very slow why? Pin
Sandeep Tripathi25-Mar-15 2:16
Sandeep Tripathi25-Mar-15 2:16 
GeneralRe: Sql server 2008 R2 Express Edition working very slow why? Pin
Eddy Vluggen25-Mar-15 3:11
professionalEddy Vluggen25-Mar-15 3:11 
GeneralRe: Sql server 2008 R2 Express Edition working very slow why? Pin
Corporal Agarn25-Mar-15 4:00
professionalCorporal Agarn25-Mar-15 4:00 
AnswerRe: Sql server 2008 R2 Express Edition working very slow why? Pin
Tim Carmichael25-Mar-15 2:33
Tim Carmichael25-Mar-15 2:33 
GeneralRe: Sql server 2008 R2 Express Edition working very slow why? Pin
Sandeep Tripathi25-Mar-15 2:43
Sandeep Tripathi25-Mar-15 2:43 
GeneralRe: Sql server 2008 R2 Express Edition working very slow why? Pin
Tim Carmichael25-Mar-15 2:52
Tim Carmichael25-Mar-15 2:52 

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.