delphi SQL语句

来源：百度知道编辑：UC知道时间：2024/09/28 14:35:47

select * from g_wip where lot_id=(select lot_id from g_sn where serial_number='1170EA07H03BC0D8X16LL190056')and station_key='80' and next_station='85' order by work_date

在上面查到的数据中怎么选择前32条信息

select top 32 * from g_wip where lot_id=(select lot_id from g_sn where serial_number='1170EA07H03BC0D8X16LL190056')and station_key='80' and next_station='85' order by work_date

这样子试试看

select top 32 * from g_wip where lot_id=(select lot_id from g_sn where serial_number='1170EA07H03BC0D8X16LL190056')and station_key='80' and next_station='85' order by work_date

Delphi 中SQL语句 delphi 中SQL语句用Delphi如何写这个SQL语句？求delphi连接SQL的语句? SQL语句在DELPHI里怎么用？ delphi 中sql语句总是有问题 delphi sql 语句FROM子句错误问题。 delphi 用sql select 语句的问题在delphi SQL语句中更新出错 Delphi中查询整型的sql语句