ChinaUnix.net
相关文章推荐:

sql 多个条件排序

select citycode,sum(value) from table group by citycode; 结果为条记录,C++怎么接收这些结果!

by shri2573 - C/C++ - 2008-06-20 10:49:36 阅读(830) 回复(2)

相关讨论

创建表: CREATE TABLE data1 ( ti INTEGER, di CHAR(4), data CHAR(12), rec_time INTEGER, format CHAR(1) ); 查询: SELECT * FROM data_rt; 想对查询得到的记录先以ti从小到大排序,再就是在同一ti里,按di从小到大排序 请教怎么写sql语句?

by reer - C/C++ - 2009-06-10 21:32:54 阅读(2412) 回复(5)

现在我又一sql文件内容大概如下: update operaters set operid='00001' where opername='aaa'; update operaters set operid='00002' where opername='bbb'; update operaters set operid='00003' where opername='ccc'; update operaters set operid='00005' where opername='ddd'; update operaters set operid='00006' where opername='ee'; update operaters set operid='00007' where opername='fdf'; update operaters se...

by remen - MySQL - 2008-07-20 16:51:27 阅读(2189) 回复(7)

1. 我现在有表,每表的结构都一样,我现在想取出所有表中A列的和,这sql语句怎么写呢? 2.表名能否做成变量,弹出对话框让用户自动填写? 谢谢大虾!

by jason.wang - MySQL - 2006-05-10 13:45:30 阅读(1168) 回复(2)

ndb_mgmd --config-file=/var/lib/mysql-cluster/config.ini --initial 2009-09-09 08:53:28 [MgmSrvr] INFO -- NDB Cluster Management Server. mysql-5.1.34 ndb-7.0.6 2009-09-09 08:53:28 [MgmSrvr] INFO -- Reading cluster configuration from '/var/lib/mysql-cluster/config.ini' 2009-09-09 08:53:28 [MgmSrvr] ERROR -- at line 31: Unable to lookup/illegal hostname 172.16.20.119:3307 - [TCP] starting ...

by justlooks - MySQL - 2009-09-10 16:39:17 阅读(2326) 回复(6)
by langaixue - Oracle - 2009-02-05 13:58:14 阅读(1365) 回复(2)

表 product 产品; tag 关键字; product_tag 关联表; 关系是product.id = product_tag.productId和tag.id = product_tag.tagId 用户在搜索框里输入了关键字(以空格隔开),要求查出同时具有这些关键字的产品 请问这语句该咋写?(用户输入的关键字已经用程序切分)

by 野鬼 - MySQL - 2009-01-03 11:04:55 阅读(2060) 回复(9)

想用RECORD类型 编译报错 我是这么写的 CREATE OR REPLACE FUNCTION REPORT.F_Sum_Var( p_C_PLY_NO IN VARCHAR2 ) RETURN RECORD -这里报错“必须说明标识符 'RECORD'”,应该怎么写呢 IS ... 小女子谢各位大侠了

by christine6280 - Oracle - 2007-09-03 15:24:06 阅读(3323) 回复(0)
by heartk - Oracle - 2005-06-30 15:10:22 阅读(2081) 回复(5)

请问如何在proc程序中定义sql通讯区,并且如何进行切换。谢谢。

by ymr - Oracle - 2004-07-02 11:14:36 阅读(744) 回复(0)