ORACLE中的 SQL的语句问题(页 1) - Oracle

s6gy 发表于 2007-4-13 16:29

ORACLE中的 SQL的语句问题

Sql = "select * from (select row_.*,rownum rownum_ from(" &_ "select t1.group_id,t1.group_name,t1.group_desc,t2.real_name from icms_group t1,icms_user t2 " &_ "where t2.user_id = t1.builder_id order by t1.group_id desc" &_ ") row_ where rownum <= " & intEndRow & ") where rownum_ >= " & intStartRow 帮我转成标准的语句撒 我看不懂了 老大门帮一哈忙撒 THANKS

davidah 发表于 2007-4-19 23:27

你写的这个语句好象有错误哟 第一层的查询语句没有 from 好象!你自己再好象检查一下!我也不太懂! Sql = " select * from (select row_.*,rownum rownum_ from (" &_ "select t1.group_id, t1.group_name, t1.group_desc, t2.real_name from icms_group t1,icms_user t2 " &_ "where t2.user_id = t1.builder_id order by t1.group_id desc" & ") row_where rownum <= " & intEndRow & ") where rownum_ >= " & intStartRow
[align=right][color=#000066][此贴子已经被作者于2007-4-19 23:30:25编辑过][/color][/align]

jiushiwo 发表于 2007-4-20 08:48

[em05]

chenxiao 发表于 2007-5-1 09:27

是一个连接查询哟 group_id, t1.group_name, (表一) t1.group_desc, t2.real_name （表二） 从二张表中进行查询数据

页: [1]

ORACLE中的 SQL的语句 问题

ORACLE中的 SQL的语句问题