Tuesday, February 10, 2009

Query in Pages - TSQL (2005)

WITH myaddress AS
(
SELECT ROW_NUMBER() OVER(ORDER BY id) AS 'RowNumber', *
FROM address
)
SELECT *
FROM myaddress
WHERE RowNumber BETWEEN 790000 AND 790050;

No comments:

如何发掘出更多退休的钱?

如何发掘出更多退休的钱? http://bbs.wenxuecity.com/bbs/tzlc/1328415.html 按照常规的说法,退休的收入必须得有退休前的80%,或者是4% withdrawal rule,而且每年还得要加2-3%对付通胀,这是一个很大...