Click here to Skip to main content
15,846,726 members
Home / Discussions / Database
   

Database

 
QuestionConvert msaccess pivot to mssql pivot Pin
kdaras30-Mar-15 23:22
kdaras30-Mar-15 23:22 
AnswerRe: Convert msaccess pivot to mssql pivot Pin
CHill6031-Mar-15 3:44
mveCHill6031-Mar-15 3:44 
GeneralRe: Convert msaccess pivot to mssql pivot Pin
kdaras31-Mar-15 20:45
kdaras31-Mar-15 20:45 
GeneralRe: Convert msaccess pivot to mssql pivot Pin
CHill6031-Mar-15 21:43
mveCHill6031-Mar-15 21:43 
Questionretrieving index info Pin
loyal ginger30-Mar-15 10:39
loyal ginger30-Mar-15 10:39 
AnswerRe: retrieving index info Pin
Sascha Lefèvre30-Mar-15 14:07
professionalSascha Lefèvre30-Mar-15 14:07 
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 
AnswerRe: Get a single record for each user Pin
Afzaal Ahmad Zeeshan26-Mar-15 0:17
professionalAfzaal Ahmad Zeeshan26-Mar-15 0:17 
A simple solution would be,

SQL
SELECT TOP 1 * FROM DeviceLogs ORDER BY LogDate; 


Which will select the top 1 record from your records, ordering them by your column containing LogData, you can add or remove DESC at the end of the ORDER BY clause if it returns the opposite side and so on.
The sh*t I complain about
It's like there ain't a cloud in the sky and it's raining out - Eminem
~! Firewall !~

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
professionalAfzaal 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 

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.