l*****o 发帖数: 61 | 1 有一组数据,数据结果如下:
Year FieldID Ntreatment Replication Nform Ntiming Yield
2009 ST001 100 1 AA Spring 182
2009 ST001 100 2 AA Spring 186
2009 ST001 100 3 AA Spring 176
2009 ST001 150 1 AA Spring 190
2009 ST001 150 2 AA Spring 198
2009 ST001 150 3 AA Spring 172
2009 ST001 200 1 AA Spring 200
2009 ST001 200 2 AA Spring 195
2009 ST001 200... 阅读全帖 |
|
l**o 发帖数: 3 | 2 we can implement sp on sysbase in java with this way.
stmt.execute(sqlstmt).
//execute next statement
"create procedure MMSP( @id " + "int" + ", @ordinal integer
)" + NEWLINE +
"as begin" + NEWLINE +
// List the clones of this field and remove this field
from the list
"exec MB_MDListClones @id" + NEWLINE +
// Propagate ordinal info for links
"update MB_MDDefinition set ordinal = @ordinal " +
"where fieldId in (select fieldId from " +
MB_CLONE_TEMP_TABLE_NAME + " where id |
|
l**o 发帖数: 3 | 3 we can implement sp on sysbase in java with this way.
stmt.execute(sqlstmt).
//execute next statement
"create procedure MMSP( @id " + "int" + ", @ordinal integer
)" + NEWLINE +
"as begin" + NEWLINE +
// List the clones of this field and remove this field
from the list
"exec MB_MDListClones @id" + NEWLINE +
// Propagate ordinal info for links
"update MB_MDDefinition set ordinal = @ordinal " +
"where fieldId in (select fieldId from " +
MB_CLONE_TEMP_TABLE_NAME + " where id |
|
|
s***f 发帖数: 173 | 5 其实主要是关于数据库的.
比如我有一个PAGE叫CREATE EVENT.ASP, 通过SUBMIT这个PAGE,
我想要在下一个PAGE(叫SHOW EVENT.ASP)中显示CREATE EVENT中选择的项目.
具体说就是, 在CREATE EVENT.ASP中有很多CHECKBOX(比如, FIRST NAME--CHECKBOX
LASTNAME--CHECKBOX EMAIL--CHECKBOX..), 那么我要在SHOW EVENT.ASP中显示CREATE
EVEN.ASP中已经选择了的CHECKBOX的选项的名字(比如FIRST NAME, EMAIL..), 并且后面
还要再加上TEXTBOX从而让USER去INPUT(比如就变成了,FIRST NAME -- TEXTBOX, LAST
NAME -- TEXTBOX..).
而且我被要求一定要将把被CHECK过的CHECKBOX的名字存储到DATABASE中. 我本来打算这
么做: 一个TABLE叫FIELD, 包括FIELDID,FIELDNAME.
但是我发现,如果这么做的话,比如第一次,我存储的结果是: |
|
h***i 发帖数: 11 | 6 hi, DB experts. here i have an problem to create this query:
i have a table:
T1 {fieldID, fieldvisitTime, fieldUserID, fieldIP}
now i want:
get the last visit time and its corresponding IP for each userID.
I think it's possible to make this query in one SQL sentence. but how?
thanks in advance!!!!!!!!!!!! |
|
m**c 发帖数: 90 | 7
Should you group by all fields instead of just fieldUserID:
... GROUP BY fieldUserID, lastTime, fieldID
by |
|
k*******a 发帖数: 772 | 8 I guess you need group by year fieldID |
|
l****u 发帖数: 529 | 9 proc sql;
create table ylddiff as
select DISTINCT A.Year, A.FieldID, A.NForm, A.NTiming |
|