Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- TableA
- DateAdded Data1 Data2
- 1/1/2012 a b
- 1/3/2012 c d
- 1/2/2012 e f
- TableB
- DateAdded Data3 Data4
- 1/6/2012 g h
- 1/5/2012 i j
- 1/4/2012 k l
- TableC
- DateAdded Data5 Data6
- 1/8/2012 m n
- 1/9/2012 o p
- 1/7/2012 q r
- private DateTime GetEndTime()
- {
- DateTime retVal = new DateTime();
- DateTime sa = new DateTime();
- DateTime gps = new DateTime();
- SQLiteCommand cmd = mySQL.CreateCMD();
- SQLiteDataReader dbReader = mySQL.ExecuteQuerySQL("SELECT DateAdded FROM DF ORDER BY ROWID DESC LIMIT 1", cmd);
- if (dbReader.HasRows)
- {
- dbReader.Read();
- retVal = dbReader.GetDateTime(0);
- }
- dbReader.Close();
- dbReader = mySQL.ExecuteQuerySQL("SELECT DateAdded FROM SA ORDER BY ROWID DESC LIMIT 1", cmd);
- if (dbReader.HasRows)
- {
- dbReader.Read();
- sa = dbReader.GetDateTime(0);
- }
- dbReader.Close();
- if (retVal < sa)
- retVal = sa;
- dbReader = mySQL.ExecuteQuerySQL("SELECT DateAdded FROM GPS ORDER BY ROWID DESC LIMIT 1", cmd);
- if (dbReader.HasRows)
- {
- dbReader.Read();
- gps = dbReader.GetDateTime(0);
- }
- dbReader.Close();
- mySQL.disposeCMD(cmd);
- if (retVal < gps)
- retVal = gps;
- return retVal;
- }
- select MAX(MaxDateAdded) from
- (
- select MAX(DateAdded) as MaxDateAdded from a
- union
- select MAX(DateAdded) as MaxDateAdded from b
- union
- select MAX(DateAdded) as MaxDateAdded from c
- ) AS UnionedDateAddedTables
- SELECT MAX(DateAdded)
- FROM
- (
- SELECT MAX(DateAdded) AS DateAdded FROM tableA
- UNION
- SELECT MAX(DateAdded) AS DateAdded FROM tableb
- UNION
- SELECT MAX(DateAdded) AS DateAdded FROM tablec
- )
- Instead of selecting all rows
- SEELCT MAX(DateAdded) AS DateAdded FROm table
Add Comment
Please, Sign In to add comment