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

from table1

order by num1 desc) as a

order by num1 asc) as b

order by num1 asc) as c

order by num1 desc

Top

取出最先的是select top *from tablename

取出最后的几条是什么？

Top

select count(*) from tb_tablename

经常用的，取记录数

Top

t tigerflyfly()

还是用select top,只是排序倒过来即可，比如：

select top 10 * from tablename order by id desc

Top

to tigerflyfly()

用排序呀。

Top

分页语句

select top 100 * from 表名 where id not in (select top page_no*100 * from 表名)

page_no是程序中的变量

Top

我收藏

中午来看

Top

从直接输出XML数据:

select text1,text2 from table1 where text1 like '%alu_ok%' for xml auto

Top

UPDATE titles

SET t.ytd_sales = t.ytd_sales + s.qty

FROM titles t, sales s

WHERE t.title_id = s.title_id

AND s.ord_date = (SELECT MAX(sales.ord_date) FROM sales)

Top

up

Top

DELETE authors

FROM (SELECT TOP 10 * FROM authors) AS t1

WHERE authors.au_id = t1.au_id

Top

初始化表table1

TRUNCATE TABLE table1

Top

cnuninet() :晕～～

Top

从入库信息表和入库清单表中得期初期末库存：

SELECT a.mattype as mattype, a.matname as matname, a.spec as spec,a.indate as indate, a.amount AS lastnum, a.matsum AS lastsum,

b.amount AS curnum, b.matsum AS cursum

FROM (SELECT a.mattype, a.matname, a.spec, TO_CHAR(a.indate, 'yyyy-mm') AS indate,

SUM(b.amount) AS amount, SUM(b.matsum) AS matsum

FROM (SELECT a.mattype, a.matname, a.spec, a.indate, SUM(nvl(a.amount, 0)

- NVL(b.amount, 0) + NVL(c.amount, 0)) AS amount, SUM(nvl(a.matsum,

0) - NVL(b.matsum, 0) + NVL(c.matsum, 0)) AS matsum

FROM (SELECT a.mattype AS mattype, a.matname AS matname,

a.spec AS spec, b.indate AS indate, a.amount AS amount,

a.matsum AS matsum, b.matsource AS matsource

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