从历史记录表中选择最新状态

SELECT * FROM history_table
WHERE status = (
  SELECT MAX(status) FROM history_table
)

import sqlite3

conn = sqlite3.connect('example.db')
cursor = conn.cursor()

cursor.execute("SELECT * FROM history_table WHERE status = (SELECT MAX(status) FROM history_table)")
rows = cursor.fetchall()

for row in rows:
    print(row)

const mysql = require('mysql');

const connection = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: 'password',
  database: 'example_db'
});

connection.connect();

connection.query("SELECT * FROM history_table WHERE status = (SELECT MAX(status) FROM history_table)", (error, results, fields) => {
  if (error) throw error;
  console.log(results);
});

connection.end();