SELECT 
  RunID, 
  Rank,  
  Timestamp,
  Score
FROM (
  SELECT 
    RunID, 
    ROW_NUMBER() OVER (ORDER BY Score DESC) AS Rank,    
    Timestamp,
	Score,
    CASE 
      WHEN Timestamp = (
        SELECT MAX(Timestamp) 
        FROM Stats         
      ) THEN 1 
      ELSE 0 
    END AS IsLatest
  FROM Stats  
) 
ORDER BY IsLatest DESC, Score DESC
LIMIT 10

 [ContextMenu("RowNumberTest")]
 public void SchemaTest()
 {
     path = Application.persistentDataPath + "/" + "Stats.sqlite";
     connection = "URI=file:" + path;
     // Open connection
     dbcon = new SqliteConnection(connection);
     dbcon.Open();

     // Create table
     IDbCommand dbcmd;
     dbcmd = dbcon.CreateCommand();
     string q_createTable = @"
     CREATE TABLE IF NOT EXISTS Stats (
         RunID INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE,       
         Timestamp DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL,	           
         Score REAL	            
     )";

     dbcmd.CommandText = q_createTable;
     dbcmd.ExecuteReader();

     string query = $"SELECT \r\n  RunID, \r\n  Rank,  \r\n  Timestamp,\r\n  Score\r\nFROM (\r\n  SELECT \r\n    RunID, \r\n    ROW_NUMBER() OVER (ORDER BY Score DESC) AS Rank,    \r\n    Timestamp,\r\n\tScore,\r\n    CASE \r\n      WHEN Timestamp = (\r\n        SELECT MAX(Timestamp) \r\n        FROM Stats         \r\n      ) THEN 1 \r\n      ELSE 0 \r\n    END AS IsLatest\r\n  FROM Stats  \r\n) \r\nORDER BY IsLatest DESC, Score DESC\r\nLIMIT 10";
     Debug.Log($"Select query: {query}");
     IDbCommand cmnd_read = dbcon.CreateCommand();
     cmnd_read.CommandText = query;
     IDataReader reader = cmnd_read.ExecuteReader();

     List<Dictionary<string, object>> statsList = new List<Dictionary<string, object>>();
     while (reader.Read())
     {
         Dictionary<string, object> statsDict = new Dictionary<string, object>();
         for (var i = 0; i < reader.FieldCount; i++)
         {
             statsDict.Add(reader.GetName(i), reader[i]);
             Debug.Log($"{reader.GetName(i)} {reader[i]}");
         }
         statsList.Add(statsDict);
     }
 }