在ORACLE 中
Select * From
(Select Rownum id,c.* From (select * from "covercharge" t Order By chargemoney Desc) c )
Where id>10 And id <=20那在MS SQL SERVER 和 ACCESS中,我该如何写分页显示的SQL呀?
Select * From
(Select Rownum id,c.* From (select * from "covercharge" t Order By chargemoney Desc) c )
Where id>10 And id <=20那在MS SQL SERVER 和 ACCESS中,我该如何写分页显示的SQL呀?
SELECT DISTINCT au_fname, au_lname
FROM authors
GOSELECT TOP 50 PERCENT au_fname, au_lname
FROM authors
GOSELECT TOP 5 au_fname, au_lname
FROM authors
GO
select top n from ....---------------------------------------------------select top n from在oracle里面不能够用啊,请教原因
ora-00023未找到预期的from
难道非要用存储过程?