求一条查询语句，显示该报价单每行的最小报价金额和最大报价金额

---涛声依旧--- 2008-11-04 03:13:01
--建立测试环境
CREATE TABLE [dbo].[tabquoteprice](
[quoteno] [int] NULL,
[line_no] [int] NULL,
[price] [decimal](13, 4) NULL,
[line_seq] [int] NULL,
[minqty] [decimal](13, 4) NULL,
[maxqty] [decimal](13, 4) NULL,
) ON [PRIMARY]

insert into [tabquoteprice]
select
'85003061', '1', 2.3800, 1, 100.0000, 999.0000 union all select
'85003061', '1', 1.9300, 2, 1000.0000, 9999.0000 union all select
'85003061', '1', 1.7000, 3, 10000.0000, 999999.0000 union all select
'85003061', '2', 7.6800, 1, 500.0000, 999.0000 union all select
'85003061', '2', 7.0900, 2, 1000.0000, 9999.0000 union all select
'85003061', '2', 5.2200, 3, 10000.0000, 999999.0000 union all select
'85003061', '4', 19.0800,1, 1000.0000, 4999.0000 union all select
'85003061', '4', 17.4900,2, 5000.0000, 9999.0000 union all select
'85003061', '4', 16.1400,3, 10000.0000, 99999.0000 union all select
'85003061', '4', 15.8900,4, 100000.0000, 999999.0000 union all select
'85003061', '5', 2.4200, 1, 100.0000, 999.0000 union all select
'85003061', '5', 2.1400, 2, 1000.0000, 9999.0000 union all select
'85003061', '5', 1.8500, 3, 10000.0000, 999999.0000 union all select
'85003061', '6', 21.6000,1, 20.0000, 49.0000 union all select
'85003061', '6', 18.0000,2, 50.0000, 99.0000 union all select
'85003061', '6', 16.7000,3, 100.0000, 999999.0000

--求一条查询语句，显示85003061报价单的每个line_no的最小报价金额和最大报价金额。
/*
公式：
1.最小报价金额：MinQuoteAmount=[minqty]*[price]
2.最大报价金额：MaxQuoteAmount=[maxqty]*[price]

要求：
1.求一条查询语句;
2.显示出quoteno,line_no,MinQuoteAmount,MaxQuoteAmount
3.正确结果为：
quoteno line_no MinQuoteAmount MaxQuoteAmount
85003061 1 238.000000 1699998.300000
85003061 2 3840.000000 5219994.780000
85003061 4 19080.000000 1613983.860000
85003061 5 242.000000 1849998.150000
85003061 6 432.000000 16699983.300000
*/
...全文
229 36 打赏 收藏 转发到动态 举报
写回复
用AI写文章
36 条回复
切换为时间正序
请发表友善的回复…
发表回复
zdgood 2008-11-04
  • 打赏
  • 举报
 回复
lz的结果有点小错吧！


'85003061', '4', 999999.0800,1, 1000.0000, 4999.0000 union all select 

'85003061', '4', 17.4900,2, 5000.0000, 9999.0000 union all select 

'85003061', '4', 16.1400,3, 10000.0000, 99999.0000 union all select 

'85003061', '4', 15.8900,4, 100000.0000, 999999.0000 union all select 



/*85003061	4	999999080.00000000	15889984.11000000



/*85003061           4            999999080.000000               1613983.860000
等不到来世 2008-11-04
  • 打赏
  • 举报
 回复
我来晚了……一步
律己修心 2008-11-04
  • 打赏
  • 举报
 回复 
select a.quoteno,a.line_no,min(minqty*minp) as MinQuoteAmount,max(maxqty*maxp) as MaxQuoteAmount 

from tabquoteprice a

inner join 

(select quoteno,line_no,price as minp from tabquoteprice t

where not exists(select 1 from tabquoteprice where t.quoteno=quoteno and t.line_no=line_no and t.minqty<minqty)) b

on a.quoteno=b.quoteno

and a.line_no=b.line_no

inner join 

(select quoteno,line_no,price as maxp from tabquoteprice t

where not exists(select 1 from tabquoteprice where t.quoteno=quoteno and t.line_no=line_no and t.maxqty>maxqty)) c

on a.quoteno=c.quoteno

and a.line_no=c.line_no

group by a.quoteno,a.line_no

order by a.quoteno,a.line_no

/*

quoteno	line_no	MinQuoteAmount	MaxQuoteAmount

85003061	1	170.00000000	999998380000.62000000

85003061	2	2610.00000000	999998680000.32000000

85003061	4	15890.00000000	999998080000.92000000

85003061	5	185.00000000	999998420000.58000000

85003061	6	334.00000000	999998600000.40000000

*/

utpcb 2008-11-04
  • 打赏
  • 举报
 回复 


散分贴绝对！ 你说price  这个你按照这下面2种方法自己 换就是咯 

这个是我最先开始写的1.

select distinct t1.quoteno ,t1.line_no,(select min(minqty*price) from [tabquoteprice] where quoteno= t1.quoteno and line_no=t1.line_no) as MinQuoteAmount

,(select max(maxqty*price)  from [tabquoteprice] where quoteno= t1.quoteno and line_no=t1.line_no)as MaxQuoteAmount

 from tabquoteprice t1



这个李斌写的

2.select

    t.quoteno,t.line_no,

    (select top 1 minqty*price from tabquoteprice where quoteno=t.quoteno and line_no=t.line_no order by minqty ),

    (select top 1 maxqty*price from tabquoteprice where quoteno=t.quoteno and line_no=t.line_no order by maxqty desc)

from

    tabquoteprice t

group by

    t.quoteno,t.line_no

类似你自己改吧 就按照这种方法你不管怎么要都可以取出来 如果你想效率高一点就要研究了
等不到来世 2008-11-04
  • 打赏
  • 举报
 回复 
select	quoteno,line_no

		,MinQuoteAmount=min([minqty])*(select top 1 [price] from [tabquoteprice] where quoteno='85003061' and line_no=a.line_no order by [minqty])

		,MaxQuoteAmount= max([maxqty])*(select top 1 [price] from [tabquoteprice] where quoteno='85003061' and line_no=a.line_no order by [maxqty] desc)

from [tabquoteprice] a

where quoteno='85003061'

group by quoteno,line_no

/*

quoteno     line_no     MinQuoteAmount                          MaxQuoteAmount

----------- ----------- --------------------------------------- ---------------------------------------

85003061    1           99999938.00000000                       1699998.30000000

85003061    2           499999840.00000000                      5219994.78000000

85003061    4           999999080.00000000                      15889984.11000000

85003061    5           99999942.00000000                       1849998.15000000

85003061    6           19999992.00000000                       16699983.30000000



(5 row(s) affected)



*/
水族杰纶 2008-11-04
  • 打赏
  • 举报
 回复
[Quote=引用 21 楼 rockyljt 的回复:]
此贴并非散分贴哦。谁先做出来200分就归谁。
[/Quote]
if object_id('[tabquoteprice]')is not null drop table [tabquoteprice]

go

CREATE TABLE [dbo].[tabquoteprice]( 

[quoteno] [int] NULL, 

[line_no] [int] NULL, 

[price] [decimal](13, 4) NULL, 

[line_seq] [int] NULL, 

[minqty] [decimal](13, 4) NULL, 

[maxqty] [decimal](13, 4) NULL, 

) ON [PRIMARY] 

insert into [tabquoteprice] select 

'85003061', '1', 2.3800, 1, 100.0000, 999.0000 union all select 

'85003061', '1', 1.9300, 2, 1000.0000, 9999.0000 union all select 

'85003061', '1', 1.7000, 3, 10000.0000, 999999.0000 union all select  

'85003061', '2', 7.6800, 1, 500.0000, 999.0000 union all select 

'85003061', '2', 7.0900, 2, 1000.0000, 9999.0000 union all select 

'85003061', '2', 5.2200, 3, 10000.0000, 999999.0000 union all select 

'85003061', '4', 19.0800,1, 1000.0000, 4999.0000 union all select 

'85003061', '4', 17.4900,2, 5000.0000, 9999.0000 union all select 

'85003061', '4', 16.1400,3, 10000.0000, 99999.0000 union all select 

'85003061', '4', 15.8900,4, 100000.0000, 999999.0000 union all select 

'85003061', '5', 2.4200, 1, 100.0000, 999.0000 union all select 

'85003061', '5', 2.1400, 2, 1000.0000, 9999.0000 union all select 

'85003061', '5', 1.8500, 3, 10000.0000, 999999.0000 union all select 

'85003061', '6', 21.6000,1, 20.0000, 49.0000 union all select 

'85003061', '6', 18.0000,2, 50.0000, 99.0000 union all select 

'85003061', '6', 16.7000,3, 100.0000, 999999.0000 

select quoteno ,    line_no ,     sum(MinQuoteAmount)MinQuoteAmount,      sum(MaxQuoteAmount)MaxQuoteAmount from (

select quoteno ,   line_no ,   MinQuoteAmount =   minqty*price,0 MaxQuoteAmount from (

select * from  [tabquoteprice] t where not exists(select 1 from  [tabquoteprice] where [line_no]=t.[line_no] and [minqty]<t.[minqty] ))s

union all

select quoteno ,   line_no ,  0, MaxQuoteAmount =  maxqty*price from (

select * from  [tabquoteprice] t where not exists(select 1 from  [tabquoteprice] where [line_no]=t.[line_no] and [minqty]>t.[minqty] ))k)g

group by quoteno ,    line_no



/*quoteno     line_no     MinQuoteAmount                           MaxQuoteAmount                           

----------- ----------- ---------------------------------------- ---------------------------------------- 

85003061    1           238.00000000                             1699998.30000000

85003061    2           3840.00000000                            5219994.78000000

85003061    4           19080.00000000                           15889984.11000000

85003061    5           242.00000000                             1849998.15000000

85003061    6           432.00000000                             16699983.30000000



(影響 5 個資料列)

*/
让你望见影子的墙 2008-11-04
  • 打赏
  • 举报
 回复 




select quoteno,line_no,min(MinQuoteAmount) as MinQuoteAmount,max(MaxQuoteAmount)as MaxQuoteAmount

from (select quoteno,line_no,MinQuoteAmount =[minqty]*[price],MaxQuoteAmount =maxqty*price

        from tabquoteprice

      ) a

group by quoteno,line_no



85003061	1	238.00000000	1699998.30000000

85003061	2	3840.00000000	5219994.78000000

85003061	4	19080.00000000	15889984.11000000

85003061	5	242.00000000	1849998.15000000

85003061	6	432.00000000	16699983.30000000
fcuandy 2008-11-04
  • 打赏
  • 举报
 回复
确实，无论是我说的price怎么取都是散分贴。

只是看对你的price怎么理解的问题了。

30分足亦
子陌红尘 2008-11-04
  • 打赏
  • 举报
 回复
try:



--建立测试环境 

CREATE TABLE [dbo].[tabquoteprice]( 

[quoteno] [int] NULL, 

[line_no] [int] NULL, 

[price] [decimal](13, 4) NULL, 

[line_seq] [int] NULL, 

[minqty] [decimal](13, 4) NULL, 

[maxqty] [decimal](13, 4) NULL, 

) ON [PRIMARY] 



insert into [tabquoteprice] 

select 

'85003061', '1', 2.3800, 1, 100.0000, 999.0000 union all select 

'85003061', '1', 1.9300, 2, 1000.0000, 9999.0000 union all select 

'85003061', '1', 1.7000, 3, 10000.0000, 999999.0000 union all select  

'85003061', '2', 7.6800, 1, 500.0000, 999.0000 union all select 

'85003061', '2', 7.0900, 2, 1000.0000, 9999.0000 union all select 

'85003061', '2', 5.2200, 3, 10000.0000, 999999.0000 union all select 

'85003061', '4', 19.0800,1, 1000.0000, 4999.0000 union all select 

'85003061', '4', 17.4900,2, 5000.0000, 9999.0000 union all select 

'85003061', '4', 16.1400,3, 10000.0000, 99999.0000 union all select 

'85003061', '4', 15.8900,4, 100000.0000, 999999.0000 union all select 

'85003061', '5', 2.4200, 1, 100.0000, 999.0000 union all select 

'85003061', '5', 2.1400, 2, 1000.0000, 9999.0000 union all select 

'85003061', '5', 1.8500, 3, 10000.0000, 999999.0000 union all select 

'85003061', '6', 21.6000,1, 20.0000, 49.0000 union all select 

'85003061', '6', 18.0000,2, 50.0000, 99.0000 union all select 

'85003061', '6', 16.7000,3, 100.0000, 999999.0000 







select

    t.quoteno,t.line_no,

    (select top 1 minqty*price from tabquoteprice where quoteno=t.quoteno and line_no=t.line_no order by minqty ),

    (select top 1 maxqty*price from tabquoteprice where quoteno=t.quoteno and line_no=t.line_no order by maxqty desc)

from

    tabquoteprice t

group by

    t.quoteno,t.line_no





drop table tabquoteprice
Liyingyue_FFS 2008-11-04
  • 打赏
  • 举报
 回复
[Quote=引用 21 楼 rockyljt 的回复:]
此贴并非散分贴哦。谁先做出来200分就归谁。
[/Quote]
还是感觉像散分
fcuandy 2008-11-04
  • 打赏
  • 举报
 回复
关健是你的price最哪个。

是聚的最小，最大price值，还是 minqty,maxqty所在记录行对应的price.

这个没说清。
YY_MM_DD 2008-11-04
  • 打赏
  • 举报
 回复 


--try it

SQL> CREATE TABLE tabquoteprice(

  2  quoteno int primary key,

  3  line_no int ,

  4  price decimal (13, 4),

  5  line_seq int,

  6  minqty decimal(13, 4),

  7  maxqty decimal(13, 4)

  8  )

  9  /



表已创建。

SQL> select tt.quoteno,tt.line_no,sum(tt.minquoteamount),sum(tt.maxquoteamount)

   from

  2  (select quoteno,line_no,minQty*price MinQuoteAmount,maxqty*price MaxQuoteAm

ount from tabquoteprice) tt

  3  group by tt.quoteno,tt.line_no order by tt.line_no;



   QUOTENO    LINE_NO SUM(TT.MINQUOTEAMOUNT) SUM(TT.MAXQUOTEAMOUNT)

---------- ---------- ---------------------- ----------------------

  85003061          1                  19168             1721673.99

  85003061          2                  63130             5298560.01

  85003061          4                1856930             17774231.4

  85003061          5                  20882             1873813.59

  85003061          6                   3002             16702823.7



SQL>
vgerz 2008-11-04
  • 打赏
  • 举报
 回复
if object_id('[tabquoteprice]')is not null drop table [tabquoteprice]
go
CREATE TABLE [dbo].[tabquoteprice](
[quoteno] [int] NULL,
[line_no] [int] NULL,
[price] [decimal](13, 4) NULL,
[line_seq] [int] NULL,
[minqty] [decimal](13, 4) NULL,
[maxqty] [decimal](13, 4) NULL,
) ON [PRIMARY]

insert into [tabquoteprice]
select
'85003061', '1', 2.3800, 1, 100.0000, 999.0000 union all select
'85003061', '1', 1.9300, 2, 1000.0000, 9999.0000 union all select
'85003061', '1', 1.7000, 3, 10000.0000, 999999.0000 union all select
'85003061', '2', 7.6800, 1, 500.0000, 999.0000 union all select
'85003061', '2', 7.0900, 2, 1000.0000, 9999.0000 union all select
'85003061', '2', 5.2200, 3, 10000.0000, 999999.0000 union all select
'85003061', '4', 19.0800,1, 1000.0000, 4999.0000 union all select
'85003061', '4', 17.4900,2, 5000.0000, 9999.0000 union all select
'85003061', '4', 16.1400,3, 10000.0000, 99999.0000 union all select
'85003061', '4', 15.8900,4, 100000.0000, 999999.0000 union all select
'85003061', '5', 2.4200, 1, 100.0000, 999.0000 union all select
'85003061', '5', 2.1400, 2, 1000.0000, 9999.0000 union all select
'85003061', '5', 1.8500, 3, 10000.0000, 999999.0000 union all select
'85003061', '6', 21.6000,1, 20.0000, 49.0000 union all select
'85003061', '6', 18.0000,2, 50.0000, 99.0000 union all select
'85003061', '6', 16.7000,3, 100.0000, 999999.0000
select quoteno,line_no,MinQuoteAmount=min([minqty]*[price]),MaxQuoteAmount=max([maxqty]*[price]) from [tabquoteprice] group by quoteno,line_no
Liyingyue_FFS 2008-11-04
  • 打赏
  • 举报
 回复
[Quote=引用 14 楼 rockyljt 的回复:]
结果是对的,但是逻辑错了。我的失误。
纠正为：
1.最小报价金额：MinQuoteAmount=[minqty]*最小数量那一笔记录所对应的单价[price]
2.最大报价金额：MaxQuoteAmount=[maxqty]*最大数量那一笔记录所对应的单价[price]
[/Quote]

select quoteno,line_no,MinQuoteAmount=min(MinQuoteAmount),MaxQuoteAmount=max(MaxQuoteAmount) from 

(select quoteno,line_no,MinQuoteAmount=minqty*price,MaxQuoteAmount=maxqty*price

from tabquoteprice) d

group by d.quoteno,d.line_no



/*

quoteno     line_no     MinQuoteAmount                          MaxQuoteAmount

----------- ----------- --------------------------------------- ---------------------------------------

85003061    1           238.00000000                            1699998.30000000

85003061    2           3840.00000000                           5219994.78000000

85003061    4           19080.00000000                          15889984.11000000

85003061    5           242.00000000                            1849998.15000000

85003061    6           432.00000000                            16699983.30000000



(5 行受影响)

*/
fcuandy 2008-11-04
  • 打赏
  • 举报
 回复
[Quote=引用 14 楼 rockyljt 的回复:]
结果是对的,但是逻辑错了。我的失误。
纠正为：
1.最小报价金额：MinQuoteAmount=[minqty]*最小数量那一笔记录所对应的单价[price]
2.最大报价金额：MaxQuoteAmount=[maxqty]*最大数量那一笔记录所对应的单价[price]
[/Quote]



CREATE TABLE [dbo].[tabquoteprice](

[quoteno] [int] NULL,

[line_no] [int] NULL,

[price] [decimal](13, 4) NULL,

[line_seq] [int] NULL,

[minqty] [decimal](13, 4) NULL,

[maxqty] [decimal](13, 4) NULL,

) ON [PRIMARY]



insert into [tabquoteprice]

select...

go



SELECT a.quoteno,a.line_no,a.price * mmi,c.price * mmx

	FROM tabquoteprice a

INNER JOIN

	(SELECT quoteno,line_no,MIN(minqty) mmi,MAX(maxqty)mmx FROM tabquoteprice GROUP BY quoteno,line_no) b

	ON a.quoteno = b.quoteno AND a.line_no=b.line_no AND a.minqty = mmi

INNER JOIN tabquoteprice c

	ON c.quoteno = b.quoteno AND c.line_no=b.line_no AND c.maxqty = mmx

/*

85003061	1	238.00000000	1699998.30000000

85003061	2	3840.00000000	5219994.78000000

85003061	4	19080.00000000	15889984.11000000

85003061	5	242.00000000	1849998.15000000

85003061	6	432.00000000	16699983.30000000

*/

GO

DROP TABLE tabquoteprice

GO
---涛声依旧--- 2008-11-04
  • 打赏
  • 举报
 回复
此贴并非散分贴哦。谁先做出来200分就归谁。
律己修心 2008-11-04
  • 打赏
  • 举报
 回复 
select a.quoteno,a.line_no,min(minqty*minp) as MinQuoteAmount,max(maxqty*maxp) as MaxQuoteAmount

from tabquoteprice a inner join (

select quoteno,line_no,min([price]) minp ,max([price]) maxp from tabquoteprice group by quoteno,line_no) b

on a.quoteno=b.quoteno

and a.line_no=b.line_no

group by a.quoteno,a.line_no

order by a.quoteno,a.line_no

/*

quoteno	line_no	MinQuoteAmount	MaxQuoteAmount

85003061	1	170.00000000	2379997.62000000

85003061	2	2610.00000000	7679992.32000000

85003061	4	15890.00000000	19079980.92000000

85003061	5	185.00000000	2419997.58000000

85003061	6	334.00000000	21599978.40000000

*/
zdgood 2008-11-04
  • 打赏
  • 举报
 回复
学习！
---涛声依旧--- 2008-11-04
  • 打赏
  • 举报
 回复
--建立测试环境
CREATE TABLE [dbo].[tabquoteprice](
[quoteno] [int] NULL,
[line_no] [int] NULL,
[price] [decimal](13, 4) NULL,
[line_seq] [int] NULL,
[minqty] [decimal](13, 4) NULL,
[maxqty] [decimal](13, 4) NULL,
) ON [PRIMARY]

insert into [tabquoteprice]
select
'85003061', '1', 999999.3800, 1, 100.0000, 999.0000 union all select
'85003061', '1', 1.9300, 2, 1000.0000, 9999.0000 union all select
'85003061', '1', 1.7000, 3, 10000.0000, 999999.0000 union all select
'85003061', '2', 999999.6800, 1, 500.0000, 999.0000 union all select
'85003061', '2', 7.0900, 2, 1000.0000, 9999.0000 union all select
'85003061', '2', 5.2200, 3, 10000.0000, 999999.0000 union all select
'85003061', '4', 999999.0800,1, 1000.0000, 4999.0000 union all select
'85003061', '4', 17.4900,2, 5000.0000, 9999.0000 union all select
'85003061', '4', 16.1400,3, 10000.0000, 99999.0000 union all select
'85003061', '4', 15.8900,4, 100000.0000, 999999.0000 union all select
'85003061', '5', 999999.4200, 1, 100.0000, 999.0000 union all select
'85003061', '5', 2.1400, 2, 1000.0000, 9999.0000 union all select
'85003061', '5', 1.8500, 3, 10000.0000, 999999.0000 union all select
'85003061', '6', 999999.6000,1, 20.0000, 49.0000 union all select
'85003061', '6', 18.0000,2, 50.0000, 99.0000 union all select
'85003061', '6', 16.7000,3, 100.0000, 999999.0000

--求一条查询语句，显示85003061报价单的每个line_no的最小报价金额和最大报价金额。
/*
公式：
1.最小报价金额：MinQuoteAmount=[minqty]*[price]
2.最大报价金额：MaxQuoteAmount=[maxqty]*[price]

要求：
1.求一条查询语句;
2.显示出quoteno,line_no,MinQuoteAmount,MaxQuoteAmount
3.正确结果为：
quoteno line_no MinQuoteAmount MaxQuoteAmount
85003061 1 99999938.000000 1699998.300000
85003061 2 499999840.000000 5219994.780000
85003061 4 999999080.000000 1613983.860000
85003061 5 99999942.000000 1849998.150000
85003061 6 19999992.000000 16699983.300000
*/
utpcb 2008-11-04
  • 打赏
  • 举报
 回复 
select distinct t1.quoteno ,t1.line_no,(select min(minqty*price) from [tabquoteprice] where quoteno= t1.quoteno and line_no=t1.line_no) as MinQuoteAmount

,(select max(maxqty*price)  from [tabquoteprice] where quoteno= t1.quoteno and line_no=t1.line_no)as MaxQuoteAmount

 from tabquoteprice t1





quoteno      line_no  MinQuoteAmount  MaxQuoteAmount 

85003061 1 238.000000     1699998.300000 

85003061 2 3840.000000     5219994.780000 

85003061 4 19080.000000     1613983.860000 

85003061 5 242.000000     1849998.150000 

85003061 6 432.000000     16699983.300000
这个对
加载更多回复（16）
SQL查询语句之查询数据
目录1、基本查询语句2、单表查询2.1 查询所有字段1、列出表中的所有字段2、使用 ‘?* ’ 查询所有字段?2.2 查询指定字段2.3 查询指定记录2.4 带 in 关键字的查询2.5 带 between and 的范围查询2.6 带 like 的字符...
SQL查询语句详解
SQL查询语句详解（一） 一、基本语法 Select select_list From table_name Where condition_expression Group by group_columns having condition_expression Order by sort_columns 二、查询实例 查询所有字段 ...
数据库操作-查询语句等相关信息
SQL语句查询 排序 通过order by语句，可以将查询出的结果进行排序。放置在select语句的最后。 格式: SELECT * FROM 表名 ORDER BY 排序字段 ASC|DESC; ASC 升序 (默认) DESC 降序 #1.使用价格排序(降序)...
SQL语句查询
微信公众号：菜鸟永恒 第1章 SQL语句查询 1.1 排序 通过order by语句，可以将查询出的结果进行排序。放置在select语句的最后。...1.查询所有商品信息,使用价格排序(降序) SELECT * FROM product ORDER BY pri...
mysql数据库之查询
– 主要的查询对象，第一条select语句 – 二者关系： – 1，子查询是嵌入到主查询中 – 2，子查询是辅助主查询的，要么充当了条件，要么充当了数据源 – 子查询是有一个可以独立存在的语句，是一个完整的select语句...
MS-SQL Server

34,590

社区成员

254,589

社区内容

发帖
与我相关
我的任务
社区描述
MS-SQL Server相关内容讨论专区
社区管理员
  • 基础类社区
  • 二月十六
  • 卖水果的net
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章