s*******o
发帖数: 194 | 1 RENAME COL1-COL5=NEW1-NEW5; |
|
|
d**********o
发帖数: 1321 | 3 RTOS作业：2514
The purpose of this assignment is to give you more experience using the AVR
ports, and to add some I/O devices that might become useful later for our
RTOS.
You are to use one of the provided keypads to implement a “digital lock.”
Your program should allow the user to enter a four digit code from the
keypad, and if the code that is input matches the one included in your
program, the “lock” should open. In this case, the lock opening will be
represented by the lighting of an LED.
As th... 阅读全帖 |
|
d**********o
发帖数: 1321 | 4 RTOS作业：2514
The purpose of this assignment is to give you more experience using the AVR
ports, and to add some I/O devices that might become useful later for our
RTOS.
You are to use one of the provided keypads to implement a “digital lock.”
Your program should allow the user to enter a four digit code from the
keypad, and if the code that is input matches the one included in your
program, the “lock” should open. In this case, the lock opening will be
represented by the lighting of an LED.
As th... 阅读全帖 |
|
n********n
发帖数: 8336 | 5 既然翻译有争议的地方，就让它存疑行了，还争什么？存疑不是只支持耶证的说法。不
存疑的地方例如耶稣也受崇拜，耶证没法解释。
我只能说耶证最初从翻译下手的，也只能在翻译上做文章，取适合耶证的翻译。期待耶
证的翻译出新版本，好自圆其说。
请列举耶稣或神的道是受造物的明确经文。
歌罗西书1：15，16（新修）：“［新修两个字用得好】
‘为什么圣经从没有说父和圣灵是“一切被造的之中底首生者”呢？惟有耶稣基督’
因为，按人类习惯，子是父生的，父与子相对而言。这表明了耶稣的位格是神的儿子，
且不论是不是首生。
还是那句话：圣父一定是雄性的吗？首生一定是人理解的生吗？神如何生儿子？
这只是人类的概念来描述神，用人类的概念来强说无限的神罢了。
神道灵就看不出有父子关系，父子是因为耶稣是道成肉身，故有父子之说。
因为不管是神道灵，还是父子灵都是对独一神的不同方面的描述，是人类概念的指代。
我觉得在中国思维的对三位一体应该更好理解，没想到出自西方思维里。赞一下！
举个不恰当的例子，镜子里的人和本人是一个人吗？当然一个是具体的人，一个是形象
。但是作为无限的无形无相的【神的形象】而言会怎样呢？
COL1：15... 阅读全帖 |
|
w**********1
发帖数: 2588 | 6 【Mat24:12】
只因不法的事增多，许多人的爱心，才渐渐冷淡了。
【Eph4:22】
就要脱去你们从前行为上的旧人。这旧人是因私欲的迷惑，渐渐变坏的。
这几段经文中，一个共同点是，都有"渐渐"一词。
人的堕落，和 人的成圣， 都不是一蹴而就的。
这个过程的特点是，今天和昨天，区别很小，每一天的区别都
很小，所以，人感觉不到自己的堕落，有足够的时间把每一次
细微的变化合理化, 于是，对善的定义经过一次一次的微调。
所以，没有几个人，能够很容易的意识到自己的堕落，
而总是倾向于认为自己对善的标准是始终如一的。
而且，一代一代人下来，很多人都觉得自己出生的环境中周遭的人，
特别是至亲的人的行为，就是完美的对善的标准的诠释，
所以很多小孩在道德标准上都是继承了自己的父母，
并以此为起点，在跟周围的环境互动中，自身的道德标准开始变化，
开始渐渐的堕落。人类的堕落就是这么继承下来的。
所以，很多堕落了的人，并没有罪恶感，因为他们觉得自己跟起初的自己，
改变的并不大，也许只是坏了一点点而已。 只不过, 70后，80后，90后，
道德标准就是这样一代不如一代的。但是，70后跟90后的比较，已经能... 阅读全帖 |
|
w*r
发帖数: 2421 | 7 em....
select * from (
select col,count(*) as cnt,
row_id() over (col1, col2) as rid
from...) a
where rid = random(1,cnt) |
|
h********l
发帖数: 67 | 8 【 以下文字转载自 Programming 讨论区 】
发信人: happyangel (快乐的天使), 信区: Programming
标 题: mySQL 问题
发信站: BBS 未名空间站 (Mon Jul 2 15:07:50 2007)
程序经常要用到下面的mysql语句(每秒一次左右):
update Table set col1=value1 where col2=value2
mysql和程序在同一台机子: P4 2800, 2G Memory
运行后，CPU使用率一直维持在100%. 请问这是什么
原因？谢谢！ |
|
D******y
发帖数: 3780 | 9 col2 should be indexed?
if col1 is set as index, it might take more CPU to re-index the table once i
t is updated |
|
w*r
发帖数: 2421 | 10 in Teradata:
insert into A select * from B qualify row_number() over (order by col1,
col2, colN) <=500 |
|
M***7
发帖数: 2420 | 11 请问下面这个QUERY为什么不WORK
SELECT *
INTO NewTable
FROM ( SELECT COL1,COL2 FROM Table1
UNION ALL
SELECT COL3,COL4 FROM Table2)
括号里的QUERY单独可以work。这里我如果想加order by 的话可以吗？
谢谢 |
|
n********6
发帖数: 1511 | 12 SELECT COL1, COL2
INTO Newtable
FROM Table1
Prerequirement: Newtable does not exist. The process will automatic create
the new table.
I do not know if you can use
(SELECT * FROM Table1
UNION ALL
SELECT * FROM Table2)
INTO NewTable |
|
b*****e
发帖数: 364 | 13 Try this one. Just add a alias name.
SELECT *
INTO NewTable
FROM ( SELECT COL1,COL2 FROM Table1
UNION ALL
SELECT COL3,COL4 FROM Table2) a |
|
|
M***7
发帖数: 2420 | 15 Hi all. I am a newbie with SQL. Here is my question:
The table is like
col1 col2 col3
a1 1 c
a1 2 a
...
a1 100 t
a2 1 d
a2 2 c
...
a2 100 g
a3 1 h
...
a3 100 d
now I am trying to make a function. The parameters are 2 ints of col2(such
as 2,81). I want to return a table containing the composition of that two
input parameters which is like
for parameter (2,81)
dt 10%
ac 40%
tt 50%
could anyone help me out? |
|
M***7
发帖数: 2420 | 16 Sorry for the confusion.
this query is like suppose I have a sequence a1 with "agdgteddgg", then I
put it into the table as below:
col1 col2 col3
a1 1 a
a1 2 g
a1 3 d
...
a1 10 g
then I get 9 other different sequences (a2-a10) and put them into the table
in the same format.
Then I want to check for all sequences, what is the combination of
composition at position 2 and position 8.
so it could be |
|
h******l
发帖数: 422 | 17 你的意思是:
假设 tbl1:
col1 col2 col3 col4 col5 col6 |
|
m*****i
发帖数: 2325 | 18 Why?
col1 is part of the primary key, it suppose to be indexed.
scan. |
|
B*****g
发帖数: 34098 | 19 from 9i, there is one thing called "Index Skip Scan", oracle may choose this
one over full table scan
col2,col1)的索引？
用该 |
|
v*****r
发帖数: 1119 | 20 ”col1 is indexed“ is not a guarantee that index will be used. For example,
if there are many rows equals 601, Oracle will not use index, why? because
full table scan will be considered cheaper/faster in that case (Assuming the
statistics are accurate).
Anyway, a quick diff of two execution plans will tell you why one is slower
and one is faster. |
|
v*****r
发帖数: 1119 | 21 ”col1 is indexed“ is not a guarantee that index will be used. For example,
if there are many rows equals 601, Oracle will not use index, why? because
full table scan will be considered cheaper/faster in that case (Assuming the
statistics are accurate).
Anyway, a quick diff of two execution plans will tell you why one is slower
and one is faster. |
|
v*****r
发帖数: 1119 | 22 ”col1 is indexed“ is not a guarantee that index will be used. For example,
if there are many rows equals 601, Oracle will not use index, why? because
full table scan will be considered cheaper/faster in that case.
Anyway, a quick diff of two execution plans will tell you why one is slower
and one is faster. |
|
B*****g
发帖数: 34098 | 23 update ...
set col2 = case when col1 = xx then 'xxxx' else 'xx' end |
|
|
t*********i
发帖数: 217 | 25 I see. Thanks a lot.
The syntax is a little strange. tbl1 get all records when tbl2 has a (+)
there. |
|
v*****r
发帖数: 1119 | 26 哈哈，如果你习惯了 +=， =+ syntax, 看 ANSI out join syntax 还觉得别扭哪。 |
|
s*******6
发帖数: 3 | 27 (+) is the best expression. ANSI out join is for some who is not a DB
developer. |
|
a9
发帖数: 21638 | 28 这个等于full outer join吗？
is |
|
|
v*****r
发帖数: 1119 | 30 To do "full outer join" using old oracle outer join syntax, you will need a
UNION to union left and right outer join.
Oracle old +=, =+ syntax in most cases are more concise than ANSI syntax,
but ANSI full outer join syntax seems more concise than += UNION =+ old
syntax. |
|
a9
发帖数: 21638 | 31 if exists (select * from tempdb.dbo.sysobjects where id = object_id(N'tempdb
..#test') and type='U')
drop table #test
select 1 as col1 into #test |
|
w****p
发帖数: 45 | 32 想请教大家一个问题，
我现在有一个TABLE有很COLUMNS， 我想根据一个COLUMN，对所有其他COLUMNS都做一个
SUM
如果只对一个COLUMN做这样的SUM,应该是这样的，
SELECT aggregatecolumn, sum(col1) AS sumcol1
FROM table
GROUP BY aggregatecolumn
现在的问题是，table里有很多列，我不想手动编辑所有列弄一个很长的SELECT句子
，而且不同的table列的名字会不一样。 如果换一个不同的TABLE，还得重新编辑。
SQL有没有比较简洁的办法？多谢了！
或者哪位有ACCESS vba code 也可以 |
|
n********6
发帖数: 1511 | 33 objective:
SELECT * FROM TABLE1
WHERE @COLUMEVariable = 'xyz'
(SQL SERVER 2005)
请问：以下dynamic sql哪里出错了？有没有其他办法？谢谢。
Declare @testvar varchar(50)
Declare @testval varchar(50);
Set @testvar = Col1;
Set @testval = 'on';
SELECT * FROM ...
WHERE @testvar is not null
and @testvar =
CASE UPPER(@testval)
WHEN 'ON' THEN 'on'
END |
|
a***y
发帖数: 2803 | 34 这是个什么表啊? 一个表肯定要有primary key,create table的时候,如果不想重复输
入一行数据,用unique(col1,col2,....)可以避免重复的数据被输入表里面. |
|
r*****l
发帖数: 2859 | 35 What if there are two records:
John|Doe|123 Main st|...|...
John|Doe1|23 Main st|...|...
I believe Oracle has something like "group by col1, col2, etc". Why don't
you use that instead of concat?
only
a |
|
i****a
发帖数: 36252 | 36 If the where clause in an update query hit multiple records for the same row
, which one gets written as the final update?
example
TableA:
Name, Value
A, 100
A, 200
A, 300
update TableB
set col1 = TableB.Value
from TableB
where TableB.Name = 'A'
i think it is by physical order but not guaranteed? |
|
z**********8
发帖数: 2049 | 37 你这个group的目的是啥？是要aggregating吗？ 还是只是要list好看点？如果是前者
，你group by primary key(s)的RESULT,有点奇怪了。
根据syntax,好像multilevel的GROUP就是group by col1,col2. |
|
s**********o
发帖数: 14359 | 38 倒出去，重新IMPORT进来，然后INSERT INTO TARGET TABLE
QUESTION WHAT IF DUPLICATE
col1 col2
a1 b11
a1 b11
a1 b11
a1 b12
a2 b21
a2 b22 |
|
c*****d
发帖数: 6045 | 39 update tabA
set col1 = NULL |
|
c*****d
发帖数: 6045 | 40 update tabA
set col1 = NULL |
|
c*****d
发帖数: 6045 | 41 sum不可以
select col1+col2 from tableA
不就行了 |
|
k***n
发帖数: 997 | 42 1， 有一个客户_good_.dbo.transactions, 其中包括
acct: unique customer identifier, purchdate: date when purchase occurred,
purchasemt: purchase amount
要求：select all acct with first purchase happened in 2012 and his total
purchase amount > 250$
2, 还是这个table, find the proportion of customers that made more than one
purchases in 2012 fiscal year. return a table where col1 is number of
customers that made more than one purchases in 2012 fiscal year, col2 total
number of customers ever purchased from us, col3 s... 阅读全帖 |
|
o**y
发帖数: 1466 | 43 I have written a procedure in a package but the performance is very slow
which takes forever to execute. After more than 1 hour now it is still
spinning. however if I run the exactly the same code within developer
without using package, the performance is totally different, and it just
takes only about 3 minutes. The pseudo code is:
insert into tab3 (.......)
with subtab1 as
(select about 27000 rows from tab1, tab2 where join_sth),
subtab2 as
(select *, function_in_the_package_deal_with_Ge... 阅读全帖 |
|
w*****m
发帖数: 20421 | 44 insert targetTable
(col1, col2, patientID)
select
'1', '2' , patientID
from
patientTable |
|
I******0
发帖数: 182 | 45 填的啥？
假如select出来的结果是 A B
刚才那个语句出来就是
col1 col2 col3
1 2 A
? ? B
这样吗？ |
|
s********e
发帖数: 893 | 46 col1 col2 col3
1 2 A
1 2 B
你用数据试一下就明白了。 |
|
w*****m
发帖数: 20421 | 47 当然是
col1 col2 col3
1 2 A
1 2 B |
|
i*******d
发帖数: 81 | 48 想到的几点：
1.A 的三个column合并成一个。这样只要比较一次。中间加个特殊字符，防止引入不该
有的match
COALESCE(col1,'') + '|' + COALESCE(col2,'') + '|' + COALESCE(col3,'')
2.可以对新的column加full text index
3.对cursor循环加终止条件，找到match了就终止。可以省一半时间。
你可以先试试1+3. |
|
l******9
发帖数: 579 | 49 the types:
col1 INT
col2 INT
col3 INT
col4 DOUBLE PRECISION
thanks ! |
|
k********e
发帖数: 702 | 50 SELECT *
FROM table2 t2
ORDER BY t2.col1 asc, t2.col2 asc, t2.col3 asc, t2.col4 asc, t2.col5 asc |
|
