Getting the latest record - Revision history

Marcin at 06:40, 14 August 2012

2012-08-14T06:40:52Z

2012-08-14T06:40:36Z

2012-08-14T06:40:25Z

2012-08-14T06:40:08Z

2012-08-14T06:39:49Z

2012-08-14T06:39:32Z

2012-07-18T10:03:37Z

2012-07-18T10:00:38Z

2012-07-17T15:26:32Z

2012-07-17T15:25:43Z

@@ Line 5: / Line 5: @@
 <div>
 I have a table like this:
 <pre>
 balance    keepplace     startdate

@@ Line 3: / Line 3: @@
 <div class=params>schema:scott</div>
 <source lang=sql class='tidy'> DROP TABLE placement</source>
 <div>
 I have a table like this:

@@ Line 2: / Line 2: @@
 <div class='ht'>
 <div class=params>schema:scott</div>
 <div>
 I have a table like this:

@@ Line 1: / Line 1: @@
 How can I get the Lastest record from SQL
 <div class='ht'>
 <source lang=sql class='tidy'> DROP TABLE placement</source>
 <div>

← Older revision		Revision as of 06:39, 14 August 2012
Line 1:		Line 1:
	How can I get the Lastest record from SQL		How can I get the Lastest record from SQL
	<div class='ht'>		<div class='ht'>
−
−

@@ Line 91: / Line 91: @@
 WHERE startdate = X.S</source>
 <div class="ecomm e-mysql" style="display: none">Sadly MySQL does not support nested SELECT statements nor does it allow views and so I don't see how this can be accomplished without copying the last date to another tables.</div>
 </div>
 {{DATE and TIME ref}}

@@ Line 32: / Line 32: @@
 INSERT INTO placement VALUES('A02','111','01 Jan 2002');
 SELECT balance, keepplace, startdate
-FROM placement, (
+FROM scott.placement, (
    SELECT balance AS B, MAX(startdate) AS S
-    FROM gisq.placement
+    FROM scott.placement
    GROUP BY balance)
 WHERE startdate = S