是使用什么语言呢?若是PB 的话,可以这样: //定义SQL语句及变量 String Sql_str="select name,birthday from table1",str1,str2,str3 //定义游标 Declare Cur_name Dynamic Cursor for DynamicStagingArea; //为动态转接域准备SQL语句 Prepare DynamicStagingArea From Sql_str; //打开游标 Open Dynamic Cur_name; //取数据 Fetch Cur_name Into :str1,:str2; //关闭游标 Close Cur_name; 最大数: SELECT MAX(birthday) INTO :str3 FROM table1
String Sql_str="select name,birthday from table1",str1,str2,str3
//定义游标
Declare Cur_name Dynamic Cursor for DynamicStagingArea;
//为动态转接域准备SQL语句
Prepare DynamicStagingArea From Sql_str;
//打开游标
Open Dynamic Cur_name;
//取数据
Fetch Cur_name Into :str1,:str2;
//关闭游标
Close Cur_name; 最大数:
SELECT MAX(birthday) INTO :str3 FROM table1