求查询语句

[山野市民]

表1
ID(自增，可以忽略) XSL LR
1 44 72
2 90 24
3 34 24
4 98 34





查询结果： minXSL minLR maxXSL minLR
34 24 98 74


问题：查询最小销售量、利润和，最大销售量 、利润

[kingtiy]

select  min(XSL), min(LR), max(XSL), min(LR) from tb 

[-晴天]

楼主提供的查询结果都不对:

create table tb(ID int,XSL int,LR int)
insert into tb select 1, 44, 72
insert into tb select 2, 90, 24
insert into tb select 3, 34, 24
insert into tb select 4, 98, 34
go
select  min(XSL), max(LR), max(XSL), max(LR) from tb 
go
drop table tb
/*
----------- ----------- ----------- -----------
34          24          98          72
(1 行受影响)


*/

最大利润...

[small_agile]

看着 楼主 结帖率：112.00% 俺也要顶顶。。

[cd731107]

select min(XSL) as minXSL,min(LR),max(XSL) as maxXSL,max(LR) as maxLR
from tb 

[oO寒枫Oo]

楼主的结贴率确实很诡异

[oO寒枫Oo]

select  min(XSL) as minXSL, min(LR) minLR , max(XSL) maxXSL , max(LR) maxLR  from tb_name 

[--小F--]

select
 min(XSL) as minXSL,min(LR),max(XSL) as maxXSL,max(LR) as maxLR
from
 tb