Mr.Cheney的专栏

create or replace view treeview asselect a.area_id par_Id, 0 men_Id, a.area_name men_Name from area aunionselect d.area_id, d.department_id , d.department_name from department d注意两个表的字段在查询中对应，

最近把平时在项目中常用到的数据库分页sql总结了下。大家可以贴出分页更高效的sql语句。需用到的参数: pageSize 每页显示多少条数据 pageNumber 页数 从客户端传来 totalRecouds 表中的总记录数 select count (*) from 表名 totalPages 总页数 totalPages=totalReco...

create or replace view treeview asselect a.area_id par_Id, 0 men_Id, a.area_name men_Name from area aunionselect d.area_id, d.department_id , d.department_name from department d注意两个表的字段在查询中对...