sql查询员工入职多少天_sql 查询四舍五入_sql怎么四舍五入(19)

Top

select * from table;

xixi

Top

table1

kzx4dm xbdm jylsfsdm ...

102 8

112 9

122 19

131 18

141 19

select top 3 with ties jylsfsdm from table1

结果：

kzx4dm xbdm jylsfsdm ...

122 19

141 19

131 18

112 9

说明：取出并列排行的所有记录

Top

说到语法我就来兴趣了，哈哈，请看:

SELECT statement::=

<query_experssion>

[ORDER BY {order_by_expression|Column_position[ASC|DESC]}

[,...n]]

[COMPUTE

{{G|COUNT|MAX|MIN|SUM}(exression)}[,...n]

[BY expression[,...n]]

]

[FOR {BROWSE |XML{RAW|AUTO|EXPLICIT}

[,XMLDATA]

[,ELEMENTS]

[,BINARY base64]

}

]

[OPTION(<query_hint>[,...n])]

<query expression>::=

{<query specification>|(<query expression>)}

[UNION[ALL]<query specification|(<query expression<)[...n]]

<query specification>::=

SELECT [ALL|DISTINCT]

[{TOP integer|TOP integer PERCENT}[WITH TIES]]

<select _list>

[INTO new_table]

[FROM{<table_source>}[,...n]]

[WHERE <search_condition>]

[GROUP BY [ALL]group_by_expression[,...n]

[WITH{CUBE|ROLLUP}]

]

[HING<search_condition>}

哎，行了吧，这还是select 语句的形式。要看完全的，喔，那可不得了喔。我不写了，累死了，呵呵

Top

关注.

Top

收藏

Top

这种好贴，不mark，不行啊

Top

UP

Top

敬请高手出贴，最好是存储过程

Top

存储过程其实没什么经典不经典.

无非是把你在VBS中实现的逻辑在sql服务端实现而已..

而高效的存储过程往往还是使用传统的sql语法来实现主要逻辑.

Top

8错8错

Top

是那个家伙对数据下了手脚^_^

create table IKnowYou

(userid varchar(30),

TableName varchar(50),

Action varchar(6),

DateT datatime,

TrrigerTableColumns.....,

TrrigerTableColumns.....)

create trriger Who_Do_It on table

for update

as

declare userid varchar(30)

declare TableName varchar(50)

declare Action varchar(6)

本文来自电脑杂谈，转载请注明本文网址：
https://www.pc-fly.com/a/ruanjian/article-30385-19.html