select * from
(
select row_number() over (order by dm) row,* from t_zycp where dm like '%4%'
) tmp where row between and 10
相关文章
- 09-21java.sql.SQLException: The server time zone value ‘�й���ʱ��’ is unrecognized or represents more tha
- 09-21SQL-Server多表关联查询并分页
- 09-21sql server已忽略重复的主键的错误分析
- 09-21数据库——SQL-SERVER CREATE-TABLES
- 09-21SQL server 嵌套查询
- 09-21Sql-Server数据库单表查询 4.3实验课
- 09-21sql server int 列 NULLIF，isnull 判断是0还是1 ，如果是0就变成1
- 09-21Data-Analyst-with-SQL-Server
- 09-21SQL_server——索引
- 09-21JAVA连接Server SQL - jdbc