使用sql 语句查询

发布网友发布时间：2023-01-10 18:56

共5个回答

热心网友时间：2023-10-26 04:28

insert into results
select * from dinggoudan where jine=(select max(jine) from dinggoudan)
order by jine asc,dingdanhao asc

热心网友时间：2023-10-26 04:28

&&字段名：金额，je;订购单,ddh
sele * from orders dist where je in (sele max(je) from orders group by ddh ) ;
order by je,ddh into tabl results

热心网友时间：2023-10-26 04:28

select 订购单 from orders a where 金额=(select max(金额) from orders b where a.职工号=b.职工号)

select a.* into results from orders a ,(select 职工号,订购单号,max(金额) from orders group by 职工号,订购单号) b where a.职工号=b.职工号 and a.订购单号=b.订购单号
order by a.金额,a.订购单号

热心网友时间：2023-10-26 04:29

你可以试下这几个命令
insert into results
select * from dinggoudan where jine=(select max(jine) from dinggoudan)
order by jine asc,dingdanhao asc

热心网友时间：2023-10-26 04:30

select top1 money
from orders
group by money
order by money