Click here to Skip to main content
15,559,491 members
Home / Discussions / Database
   

Database

 
QuestionINSERT from with a loop using MySQL Pin
Jassim Rahma30-Mar-15 5:39
Jassim Rahma30-Mar-15 5:39 
QuestionOracle create database error: Error in process: C:\app\...\product\12.1.0\dbhome_1\perl\bin\perl.exe Pin
KasGuest29-Mar-15 23:32
KasGuest29-Mar-15 23:32 
SuggestionRe: Oracle create database error: Error in process: C:\app\...\product\12.1.0\dbhome_1\perl\bin\perl.exe Pin
Kornfeld Eliyahu Peter30-Mar-15 0:43
professionalKornfeld Eliyahu Peter30-Mar-15 0:43 
GeneralRe: Oracle create database error: Error in process: C:\app\...\product\12.1.0\dbhome_1\perl\bin\perl.exe Pin
KasGuest30-Mar-15 1:34
KasGuest30-Mar-15 1:34 
AnswerRe: Oracle create database error: Error in process: C:\app\...\product\12.1.0\dbhome_1\perl\bin\perl.exe Pin
Eddy Vluggen30-Mar-15 1:57
professionalEddy Vluggen30-Mar-15 1:57 
GeneralRe: Oracle create database error: Error in process: C:\app\...\product\12.1.0\dbhome_1\perl\bin\perl.exe Pin
KasGuest30-Mar-15 2:29
KasGuest30-Mar-15 2:29 
GeneralRe: Oracle create database error: Error in process: C:\app\...\product\12.1.0\dbhome_1\perl\bin\perl.exe Pin
Eddy Vluggen30-Mar-15 2:39
professionalEddy Vluggen30-Mar-15 2:39 
QuestionGet a single record for each user Pin
Meax25-Mar-15 23:49
Meax25-Mar-15 23:49 
I have the following SQL table,


ID LogDate Name Department
-----------------------------------------------
1 3/26/2015 7:55 AM Adam HR
2 3/26/2015 7:53 AM Tony Fin
3 3/26/2015 7:59 AM Mark Mang
1 3/26/2015 8:15 AM Adam HR
3 3/26/2015 8:10 AM Mark Mang
2 3/26/2015 7:53 AM Tony Fin

i like to get this output

ID LogDate Name Department
-------------------------------------------------
2 3/26/2015 7:53 AM Tony Fin
1 3/26/2015 7:55 AM Adam HR
3 3/26/2015 7:59 AM Mark Mang

i want to get a single record for each user ordered by min LogDate.
my table name is "DeviceLogs"
AnswerRe: Get a single record for each user Pin
Afzaal Ahmad Zeeshan26-Mar-15 0:17
mveAfzaal Ahmad Zeeshan26-Mar-15 0:17 
GeneralRe: Get a single record for each user Pin
Meax26-Mar-15 0:30
Meax26-Mar-15 0:30 
GeneralRe: Get a single record for each user Pin
Afzaal Ahmad Zeeshan26-Mar-15 0:36
mveAfzaal Ahmad Zeeshan26-Mar-15 0:36 
GeneralRe: Get a single record for each user Pin
Meax26-Mar-15 0:47
Meax26-Mar-15 0:47 
GeneralRe: Get a single record for each user Pin
RUs12326-Mar-15 1:42
RUs12326-Mar-15 1:42 
AnswerRe: Get a single record for each user Pin
Simon_Whale26-Mar-15 2:11
Simon_Whale26-Mar-15 2:11 
AnswerRe: Get a single record for each user Pin
Corporal Agarn26-Mar-15 2:16
professionalCorporal Agarn26-Mar-15 2:16 
AnswerRe: Get a single record for each user Pin
Member 1155935526-Mar-15 21:28
Member 1155935526-Mar-15 21:28 
AnswerRe: Get a single record for each user Pin
Meax4-Apr-15 0:15
Meax4-Apr-15 0:15 
QuestionReason for failing to Drop Column is showing non existent Index Pin
indian14325-Mar-15 9:46
indian14325-Mar-15 9:46 
QuestionSql server 2008 R2 Express Edition working very slow why? Pin
Sandeep Tripathi25-Mar-15 1:44
Sandeep Tripathi25-Mar-15 1:44 
QuestionRe: Sql server 2008 R2 Express Edition working very slow why? Pin
Eddy Vluggen25-Mar-15 2:00
professionalEddy Vluggen25-Mar-15 2:00 
AnswerRe: Sql server 2008 R2 Express Edition working very slow why? Pin
Sandeep Tripathi25-Mar-15 2:10
Sandeep Tripathi25-Mar-15 2:10 
GeneralRe: Sql server 2008 R2 Express Edition working very slow why? Pin
Eddy Vluggen25-Mar-15 2:28
professionalEddy Vluggen25-Mar-15 2:28 
GeneralRe: Sql server 2008 R2 Express Edition working very slow why? Pin
Sandeep Tripathi25-Mar-15 2:31
Sandeep Tripathi25-Mar-15 2:31 
GeneralRe: Sql server 2008 R2 Express Edition working very slow why? Pin
Krishna Murthy G25-Mar-15 2:40
professionalKrishna Murthy G25-Mar-15 2:40 
GeneralRe: Sql server 2008 R2 Express Edition working very slow why? Pin
Sandeep Tripathi25-Mar-15 2:46
Sandeep Tripathi25-Mar-15 2:46 

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.