关于sql语句的写法

2011-12-22 03:12:41 133 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

VASP编译疑难解析—手动配置icx路径解决libintel64报错本文针对VASP编译过程中执行`make libintel64`时遇到的`icx: 没有那个文件或目录`报错，提供了详细的解决方案。核心在于手动定位Intel oneAPI编译器的绝对路径，并修改makefile中的编译器变量，从而解决因系统PATH环境变量未正确设置导致的libintel64编译失败问题。阅读详情

表#t1数据如下：



f1        listdate        remark

c          2011-12-12       

a          2011-12-02       123

b          2011-11-01       44rr4

c          2011-12-01       774

c          2011-12-09       oiiie2

d          2011-12-2        

a          2011-11-02       234

我想取当listdate最大的日期，取remark的数据，并且remark不能为空



f1        listdate        remark

a          2011-12-02       123

b          2011-11-01       44rr4

c          2011-12-09       oiiie2

注意：不能取f1=c、listdate=2011-12-12的数据，因为remark为空的。
如何写sql语句？

...全文

STC32G电调调试血泪史：从TPH1R403NL MOS管烧毁到PWM信号异常排查全记录本文详细记录了STC32G无刷电调调试过程中的常见问题与解决方案，包括MOS管烧毁、PWM信号异常等关键故障排查。通过电源系统检测、驱动电路验证及三相平衡调试等实战经验，帮助硬件爱好者快速定位问题，提升电调调试效率。特别针对TPH1R403NL等MOS管的保护措施进行了重点分析。阅读详情

fstao

MS-SQL Server 34,876 成员 254,635 内容

+ 关注 + 加入社区

切换为时间正序

pengxuan 2011-12-22

打赏
举报



if object_id('tb') is not null

   drop table tb

go

create table tb

(

 f1 varchar(10),

 listdate varchar(10),

 remark varchar(10)

)

go

insert into tb

select 'c','2011-12-12','' union all

select 'a','2011-12-02','123' union all

select 'b','2011-11-01','44rr4' union all

select 'c','2011-12-01','774' union all

select 'c','2011-12-09','oiiie2' union all

select 'd','2011-12-2','' union all

select 'a','2011-11-02','234'

go

select * from tb a where remark<>'' and not exists(select 1 from tb where f1=a.f1 and listdate>a.listdate and remark<>'')

go

/*

f1         listdate   remark

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

a          2011-12-02 123

b          2011-11-01 44rr4

c          2011-12-09 oiiie2



(3 行受影响)

*/

dawugui 2011-12-22

打赏
举报

select top 1 * from tb where remark is not null order by listdate desc

select t.* from tb t where remark is not null and listdate = (select max(listdate) from tb where f1 = t.f1 and remark is not null)

select t.* from tb t where remark is not null and not exists (select 1 from tb where f1 = t.f1 and remark is not null and listdate > t.listdate)

dawugui 2011-12-22

打赏
举报

select top 1 * from tb where remark is not null order by listdate desc

jmx123456789 2011-12-22

打赏
举报

[Quote=引用 4 楼 ap0405140 的回复:]
SQL code

create table #t1
(f1 char(3),
listdate date,
remark varchar(9))

insert into #t1
select 'c', '2011-12-12', '' union all
select 'a', '2011-12-02', '123' union all
select 'b……
[/Quote]
mark

唐诗三百首 2011-12-22

打赏
举报



create table #t1

(f1 char(3),

listdate date,

remark varchar(9))



insert into #t1

select 'c', '2011-12-12', '' union all       

select 'a', '2011-12-02', '123' union all

select 'b', '2011-11-01', '44rr4' union all

select 'c', '2011-12-01', '774' union all

select 'c', '2011-12-09', 'oiiie2' union all

select 'd', '2011-12-2', '' union all       

select 'a', '2011-11-02', '234'





select a.* 

from #t1 a

inner join

(select f1,max(listdate) maxlistdate

from #t1 where remark<>'' group by f1) b

on a.f1=b.f1 and a.listdate=b.maxlistdate



f1   listdate   remark

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

a    2011-12-02 123

b    2011-11-01 44rr4

c    2011-12-09 oiiie2



(3 row(s) affected)

勿勿 2011-12-22

打赏
举报

[Quote=引用 1 楼 qianjin036a 的回复:]
SQL code
select *
from #t1 a
where remark is not null --如果不为空串,则 remark<>'' 下同
and not exists(select 1 from #t1 where f1=a.f1 and remark is not null and listdate>a.listdate)
[/Quote]+1

--小F-- 2011-12-22

打赏
举报

select

 * 

from

 #t1 t 

where

 remark is not null 

and

 not exists(select 1 from #t1 where f1=t.f1 and remark is not null and listdate>t.listdate)

-晴天 2011-12-22

打赏
举报

select * 

from #t1 a 

where remark is not null --如果不为空串,则 remark<>'' 下同

and not exists(select 1 from #t1 where f1=a.f1 and remark is not null and listdate>a.listdate)

关于sql语句的写法

相关推荐