Click here to Skip to main content
15,557,928 members
Home / Discussions / Database
   

Database

 
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 
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 
Well you select all columns and group by LogDate.
Group by makes a single row out of all the rows that have the same LogDate in this example.
But what information is it supposed to put in ?
That's what aggregate functions are for.


However I think you should group by name, where LogDate=the day you want to select by.
You could also group by LogDate and name.
Anything that isn't in group by must be in an aggregate function.
So you have to decide which time you want to have selected (from what I deducted, first log ? ).

A bit unrelated to your question, but why do you have ID's that repeat ?
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 
GeneralRe: Sql server 2008 R2 Express Edition working very slow why? Pin
Eddy Vluggen25-Mar-15 3:04
professionalEddy Vluggen25-Mar-15 3:04 
AnswerRe: Sql server 2008 R2 Express Edition working very slow why? Pin
Tim Carmichael25-Mar-15 3:01
Tim Carmichael25-Mar-15 3:01 
GeneralRe: Sql server 2008 R2 Express Edition working very slow why? Pin
Sandeep Tripathi25-Mar-15 3:16
Sandeep Tripathi25-Mar-15 3:16 
GeneralRe: Sql server 2008 R2 Express Edition working very slow why? Pin
Eddy Vluggen25-Mar-15 4:11
professionalEddy Vluggen25-Mar-15 4:11 
GeneralRe: Sql server 2008 R2 Express Edition working very slow why? Pin
Corporal Agarn25-Mar-15 5:00
professionalCorporal Agarn25-Mar-15 5:00 

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.