本文提供了几个SQL操作示例，包括查询所有字段、指定字段查询、更新记录等操作。示例中涉及了对STKPROFITESTIMATEDETAIL表的查询与更新，特别是针对brokerid为1的情况进行了详细展示。
select * from STKPROFITESTIMATEDETAIL where brokerid = 1
select OBJID, stkcode,brokerid,estimateyear,tbeps from STKPROFITESTIMATEDETAIL where brokerid = 1
000002、000060、000063
update STKPROFITESTIMATEDETAIL SET stkcode = '000002' WHERE stkcode = 002165
select * from STKPROFITESTIMATEDETAIL where brokerid = 1
select OBJID, stkcode,brokerid,estimateyear,tbeps from STKPROFITESTIMATEDETAIL where brokerid = 1
000002、000060、000063
select OBJID, stkcode,brokerid,estimateyear,tbeps from STKPROFITESTIMATEDETAIL WHERE stkcode = 002165 and brokerid = 1
update STKPROFITESTIMATEDETAIL SET stkcode = '000002' WHERE stkcode = 002165 and brokerid = 1
扫一扫
889
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
