SQL QUERY PT. STARS INTERNASIONAL

{ Berbagi, Menulis, Dan Mengajar } Ilmu… » 7. Operating System » SQL QUERY PT. STARS INTERNASIONAL

June 2nd, 2014 | Add a Comment

InsertIntoDB
SendingDateTime
DestinationNumber
TextDecoded
Status

SELECT *
FROM `sentitems`
ORDER BY `DeliveryDateTime` DESC
LIMIT 0 , 30

SELECT InsertIntoDB,SendingDateTime,DestinationNumber,TextDecoded,Status
FROM `sentitems`
ORDER BY `DeliveryDateTime` DESC
LIMIT 0 , 30

SELECT InsertIntoDB, SendingDateTime, DestinationNumber, TextDecoded,STATUS
FROM `sentitems`
where STATUS = ‘SendingOK’
ORDER BY `SendingDateTime` ASC
LIMIT 0 , 100

SELECT InsertIntoDB, SendingDateTime, DestinationNumber, TextDecoded,
STATUS
FROM `sentitems`
WHERE STATUS = ‘SendingOK’
ORDER BY `SendingDateTime` DESC
LIMIT 0 , 100

SELECT InsertIntoDB, SendingDateTime, DestinationNumber, TextDecoded,
STATUS
FROM `sentitems`
WHERE STATUS = ‘SendingError’
ORDER BY `SendingDateTime` DESC
LIMIT 0 , 100