h******o
发帖数: 334 | 1 怎样才能不覆盖前面存？我想每一列存后，就search 一个数据。完整的code如下：
Write a binary search method, which gets a 2D array and a query as arguments
and returns the number of times that the query occurs in the array. The 2D
array is sorted by columns but not by row.
public static int count(int[][] array, int query) {
int searchTotal = 0;
//iterate each 2D array' column
for (int c=0; c < array[0].length; c++){
searchTotal += biSearch(array, query, c);
}
return searchTotal;
}
private sta... 阅读全帖 |
|
f**d
发帖数: 768 | 2 ScienceDaily (May 1, 2011) — For more than 50 years, a dominating
assumption in brain research was that nerve cells in the cortex of the
brain are organised in the form of microscopically small columns.
Subsequently, it became a textbook standard that connections are created
predominantly between nerve cells within these columns. In a review
article for the journal Frontiers in Neuroscience, Clemens Boucsein
and colleagues from the Bernstein Centers in Freiburg and Berlin show
that this view has... 阅读全帖 |
|
l******9
发帖数: 579 | 3 【 以下文字转载自 JobHunting 讨论区 】
发信人: light009 (light009), 信区: JobHunting
标 题: SQL combine two columns from two different tables no shared columns
发信站: BBS 未名空间站 (Fri Jun 27 12:46:58 2014, 美东)
On SQL server 2008, I need to get a new table by selecting two columns from
two different tables.
address (from another_table) id_num (from a cte created by me)
city_1 65
city_1 36
city_2 65
city_2 36
city... 阅读全帖 |
|
v******0
发帖数: 265 | 4 我最近在使用HILIC Column，是bare silica的那种。因为在测试摸条件阶段，所以就
拿一些tryptic digested peptide做sample,但我分出的峰基本上都很难看，很宽，而
且拖尾严重，重复性也不好，有时同一个sample,两天后用同一个column,本来peak
shape还凑或的峰变得又不好了。
我用的是HILIC-MS,mobile phase也试过加ammonium formate, pH基本在3-4，gradient
也试了不少，sample浓度从100fmol injection到10pmol injection都试过，sample一
般都resuspend在90% ACN中 （先用水溶解，再稀释到90% ACN),可结果大多不理想。不
过同样的system, 换成C18 column就非常好。
我在网上看到的一些example似乎都还不错，但大多数用的是UV detector,也有mass
spec的，不过column基本都是Amide 80或者zic-HILIC之类的，好像是有modified,不是
bared silica.
目前手头... 阅读全帖 |
|
l******9
发帖数: 579 | 5 【 以下文字转载自 JobHunting 讨论区 】
发信人: light009 (light009), 信区: JobHunting
标 题: SQL combine two columns from two different tables no shared columns
发信站: BBS 未名空间站 (Fri Jun 27 12:46:58 2014, 美东)
On SQL server 2008, I need to get a new table by selecting two columns from
two different tables.
address (from another_table) id_num (from a cte created by me)
city_1 65
city_1 36
city_2 65
city_2 36
city... 阅读全帖 |
|
|
l******9
发帖数: 579 | 7 【 以下文字转载自 Database 讨论区 】
发信人: light009 (light009), 信区: Database
标 题: SQL combine two tables into one table and add a new column
发信站: BBS 未名空间站 (Thu May 8 14:54:50 2014, 美东)
I need to combine two tables into one. Ans also, add a column (assign an int
value) to the new table on SQL. So that the rows from table1 and ones from
table2 are assigned with different values.
Example,
table1
ID1 ID2 ID3 VALUE
table2
ID1 ID2 ID3 VALUE
table3
ID1 ID2 ID3 VALUE
i need to combine ... 阅读全帖 |
|
l******9
发帖数: 579 | 8 On SQL server 2008, I need to get a new table by selecting two columns from
two different tables.
address (from another_table) id_num (from a cte created by me)
city_1 65
city_1 36
city_2 65
city_2 36
city_3 65
city_3 36
Suppose that id_num has only 65 and 36 two values. The cte has no column of
"address". the another_table has no column of id... 阅读全帖 |
|
b****t
发帖数: 114 | 9 Hi all,
I want to append new column data to a data file. The data has been formated
in a tabbed way (very clean data without any missing/empty cells). This is
usefull when I run my c/c++ code and save data each time as one or more
columns. Ideally, it will be done within c/c++ code with fstream, but it is
ok to use stript split single (or 2 column) column data into multiple
columns.
e.g.
file1:
1 2 3
2 3 4
5 6 7 |
|
f*******t
发帖数: 7549 | 10 不同column family的数据是分开存储的。hbase文件夹结构是
table / column family / hfile
不同column (qualifier)都是堆在一起的。
rowkey + column family + qualifier + timestamp才是真正的key，对应一个value。
“cell in same row”里的row如果指rowkey的话，只要cell的column family不同，就
不会存在一起。 |
|
T**********t
发帖数: 1604 | 11 看了一下Qiagen网上的faq，好像不行，虽然没提MinElute，可是估计道理一样的：
Are QIAprep and QIAquick Spin columns interchangeable?
No. While columns from the QIAprep Spin Miniprep Kit and the QIAquick PCR
Purification- and Gel Extraction Kits are based on silica-gel-membrane
technology, each is designed to work optimally within its own kit format. In
addition, the binding capacity and DNA recovery size cut-offs of the
QIAprep and QIAquick Spin columns are different. QIAprep Spin columns bind
up to 20 ug of plasmid DNA up to |
|
d******s
发帖数: 674 | 12 First of all, wrong approach: bare silica column in HILIC mode uses silanol
group for retention, which is also the main cause of peak tailing. Adding
TFA which is the common practise in RPC to suppress silanol interference
will not work here.
Why use this column in HILIC mode? Please don't say that you only have this
column.
Reverse phase for peptide/protein digest is the golden standard, and you
will have much better luck to start here. Or, if you are trying to do something
different, you can t... 阅读全帖 |
|
d**********0
发帖数: 222 | 13 拿到一组SAS DATASET，有100多个COLUMNS，但不是对每个COLUMN一一分析。有部分
COLUMN里面的值是“YES”或“NO”。现在就想对这些COLUMN进行分析，请问怎么获取
这些COLUMN的NAMES。 |
|
f*******n
发帖数: 12623 | 14 你是说Schedule CA吧？schedule CA的column B和column C是关于加州税和联邦税的一
些差别。你要看instructions。
“我没有任何什么其他收入”是什么意思？为什么你填NR？如果你没有加州以外的收入
，column D和column E是一样的。 |
|
w****p
发帖数: 45 | 15 想请教大家一个问题，
我现在有一个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 也可以 |
|
k**n
发帖数: 3989 | 16 比如有table A 有columns 十多个。
新table B有5个columns
这俩表是 （B）0-1：1（A）关系。
我要写一个GUI update table B,
看到要求是去掉B, 把B的5个columns都加到A上。
请问这样做有什么好处？
个人不喜欢太多columns的table设计。 |
|
l******9
发帖数: 579 | 17 【 以下文字转载自 JobHunting 讨论区 】
发信人: light009 (light009), 信区: JobHunting
标 题: generate unique integer ID from columns in SQL table
发信站: BBS 未名空间站 (Fri Nov 14 17:36:46 2014, 美东)
I need to generate a new column in a table in a sql database.
the given table is:
id1 value1 value2 value3 value4
9465 387 801 1990 20
All columns are integer. All columns are integer. value1 and value2 are
always 3 digits, value3 are year value, value4 is not more than 3 digits.
I need to g... 阅读全帖 |
|
l******9
发帖数: 579 | 18 【 以下文字转载自 JobHunting 讨论区 】
发信人: light009 (light009), 信区: JobHunting
标 题: generate unique integer ID from columns in SQL table
发信站: BBS 未名空间站 (Fri Nov 14 17:36:46 2014, 美东)
I need to generate a new column in a table in a sql database.
the given table is:
id1 value1 value2 value3 value4
9465 387 801 1990 20
All columns are integer. All columns are integer. value1 and value2 are
always 3 digits, value3 are year value, value4 is not more than 3 digits.
I need to g... 阅读全帖 |
|
L********g
发帖数: 4204 | 19 I am planning to do some protein purifications recently.
Is there any myc affinity column purchasable? I checked GE, there is no such
commercial column. Or people usually make their own myc column?
My lab has a FPLC system so that I really wish I can buy some column that I
can hook to the system (not a syringe of myc-matrix) .
I will giv Baozi to ppl who can help. Thanks. |
|
w********a
发帖数: 324 | 20 Qiagen kit 经常是column用完了，但是还剩很多buffer。
Miniprep kit 的column是可以单独定的。但是PCR clean-up或者Gel extraction kit
的column不能单独定。不知道大家是怎么处理的？有其他公司的column可以作为替代品
吗？
多谢！ |
|
a******5
发帖数: 1 | 21 各位版友好
我想请问有什么类型的HILIC column适合分离sulfamate类的化合物呢?
想分析Acesulfame potassium, saccharin, cyclamate
但已经试过用C18的column RPLC 调过gradient ,ion-pair都分不太开
想要试试看新型的HILIC COLUMN
但是stationary phase琳琅满目不知道哪个效果较好
有看到Luna Diol, ZIC-HILIC, TSK-Amide 80等等...
不知道版友们有什么推荐的HILIC COLUMN可供使用?
感激不尽 |
|
l******9
发帖数: 579 | 22 【 以下文字转载自 Database 讨论区 】
发信人: light009 (light009), 信区: Database
标 题: SQL combine two tables into one table and add a new column
发信站: BBS 未名空间站 (Thu May 8 14:54:50 2014, 美东)
I need to add a column with an int value to the result from a subquery on
SQL.
It is Netezza SQL.
SELECT *
FROM
(
SELECT *
FROM table1
JOIN
table2
ON table1.id1 = table2.id1
GROUP BY table1.id2, table2.id3
) AS tt_a # here, I need to add a new column to tt, c... 阅读全帖 |
|
M*********9
发帖数: 15637 | 23 是按一个数据读的。 怎么INDEX， SUBSTR一个一个弄？ 因为今后数据可能会很大，
EXCEL每次只能DELIMIT一个COLUMN。 俺在想是不是有什么方法让SAS给搞定。 不然要
使几百COLUMN，岂不要了俺的小命。
多谢。 俺自己也在乱试多COLUMN的情况。 |
|
l******9
发帖数: 579 | 24 【 以下文字转载自 Database 讨论区 】
发信人: light009 (light009), 信区: Database
标 题: SQL combine two tables into one table and add a new column
发信站: BBS 未名空间站 (Thu May 8 14:54:50 2014, 美东)
I need to add a column with an int value to the result from a subquery on
SQL.
It is Netezza SQL.
SELECT *
FROM
(
SELECT *
FROM table1
JOIN
table2
ON table1.id1 = table2.id1
GROUP BY table1.id2, table2.id3
) AS tt_a # here, I need to add a new column to tt, c... 阅读全帖 |
|
l******9
发帖数: 579 | 25 【 以下文字转载自 Database 讨论区 】
发信人: light009 (light009), 信区: Database
标 题: SQL copy a table into a new table and add a new column
发信站: BBS 未名空间站 (Fri May 23 12:05:22 2014, 美东)
need to copy a table into a new table on SQL server 2008. Also, add a new
column into the new table.
The values of the new column depends on the compare result between the new
table and another table.
Example,
Table1:
col1 col2 col3
abc 346 6546
hth 549 974
Table1_new:
col1 col2 col3 c... 阅读全帖 |
|
l******9
发帖数: 579 | 26 【 以下文字转载自 Quant 讨论区 】
发信人: light009 (light009), 信区: Quant
标 题: SQL multiply all values of a column in table
发信站: BBS 未名空间站 (Wed Jun 25 17:35:13 2014, 美东)
I need to multiply all float values of a column in table if the column value
is positive. If I find a value is null or negative or not numeric, I raise
an error in SQL server 2008 R2.
given table t0:
col
1.5
2
given table t1:
col
2
-1
5
0
null
NaN
For t0 I should get 3, for t1, I should raise an error.
... 阅读全帖 |
|
l******9
发帖数: 579 | 27 【 以下文字转载自 Database 讨论区 】
发信人: light009 (light009), 信区: Database
标 题: add column name in exporting table netezza aginity sql
发信站: BBS 未名空间站 (Fri Oct 3 01:49:56 2014, 美东)
I need to export a table (60 GB) from IBM netezza aginity sql database
workbench to a csv file.
But, the column names are missing even though I set up "skip row" as 0.
Because the file is too large, I cannot open and edit it in Excel or notepad
/notepad++.
How to add the column names ?
Any help would be appreciated.
thanks |
|
l******9
发帖数: 579 | 28 I need to generate a new column in a table in a sql database.
the given table is:
id1 value1 value2 value3 value4
9465 387 801 1990 20
All columns are integer. All columns are integer. value1 and value2 are
always 3 digits, value3 are year value, value4 is not more than 3 digits.
I need to generate a value by combining value1 to value4, suppose that it is
called "value_combine". The "value_combine" should be unique. For example,
given the different combinations... 阅读全帖 |
|
G****e
发帖数: 11198 | 29 "It’s not worth all that. Keep your diapers on, Little Brother."
"It’s not worth all that. Keep your diapers on, Little Brother."
Dueling Columns: Michigan Daily vs. State News
http://www.michigandaily.com/sports/dueling-columns
By Michael Florek (The Michigan Daily) and Anthony Odoardi (The State News)
On October 13th, 2011
In the week leading up to the Michigan-Michigan State football game each
year, football writers from the Daily and the student newspaper at Michigan
State exchange columns.... 阅读全帖 |
|
y***n
发帖数: 11 | 30 I am not sure how a commercial DB is really implemented, but my feeling is
that if a new column is added to the table, the program should get exclusive
lock on the table first and after it gets the lock, it can proceed with adding
new column, right? If so, then existing operations will not be affected
because they will either have IS or IX or S or X lock on the table and all of
them are incompatible with xlock. The program that trys to add new column will
be blocked till all existing program fin |
|
b****r
发帖数: 113 | 31 mysql version 4.0.20a, on winxp. Innodb type table.
I use "alter table tbl_name drop col_name" to drop a column,
but it failed twice.
From the dos window on XP, the comman "alter table" hang on there for ever.
After reboot the machine, the column is still there,
and data in this column are still fine.
The table has about 20 million rolls. Is the size a prolbem?
Thanks for any help. |
|
l*****b
发帖数: 82 | 32 I have another approach to change the PK column Identity (1,1) to non-auto-
increment. It looks like I have to create some temp columns or tables to
copy/remove/rebuilt the PK column. Do you think I could have other way to go
? Thank you. |
|
m******1
发帖数: 98 | 33 不好意思，又要麻烦大家了。
我有两个ACCESS Table，
Table1， 有190 patients, 有20个column.
Table 2, 有90 patients, 有 10个column.
这些column里面 有些一样，有些不一样。 patients 也是有几个重复。
想问问这种情况下能不能把两个table 合并到一起呢？
一个朋友说，是不可能并到一个的。用Query也不行。
谢谢！ |
|
k*****n
发帖数: 361 | 34 为啥不行，beijing给的link不是说
1,048,576 rows by 16,384 columns
16384 columns>2000 columns |
|
l******9
发帖数: 579 | 35 I need to add a column with an int value to the result from a subquery on
SQL.
It is Netezza SQL.
SELECT *
FROM
(
SELECT *
FROM table1
JOIN
table2
ON table1.id1 = table2.id1
GROUP BY table1.id2, table2.id3
) AS tt_a # here, I need to add a new column to tt, call it as top_id
and also assign an int value to it, such as 80
FROM
(
SELECT *
FROM table1
JOIN
table3
ON table1.id1 = table3.... 阅读全帖 |
|
h******y
发帖数: 25 | 36 求问大牛
如何在sql server中实现动态选择columns。
比如针对某一个特定id，我只想在结果中出现非null的column，如果改变id，结果中的
column应该是不一样的，请问这样的query能否实现呢？
谢谢！ |
|
l******9
发帖数: 579 | 37 【 以下文字转载自 Quant 讨论区 】
发信人: light009 (light009), 信区: Quant
标 题: SQL multiply all values of a column in table
发信站: BBS 未名空间站 (Wed Jun 25 17:35:13 2014, 美东)
I need to multiply all float values of a column in table if the column value
is positive. If I find a value is null or negative or not numeric, I raise
an error in SQL server 2008 R2.
given table t0:
col
1.5
2
given table t1:
col
2
-1
5
0
null
NaN
For t0 I should get 3, for t1, I should raise an error.
... 阅读全帖 |
|
l******9
发帖数: 579 | 38 【 以下文字转载自 JobHunting 讨论区 】
发信人: light009 (light009), 信区: JobHunting
标 题: SQL select one value column for each distinct value another col
发信站: BBS 未名空间站 (Fri Jun 27 10:29:25 2014, 美东)
On SQL server 2008 R2, I would like to select one value of a column for each
distinct value of another column.
e.g.
name id_num
Tom 53
Tom 60
Tom 27
Jane 16
Jane 16
Bill 97
Bill 83
I need to get one id_num for each distinct name, such as
name id_num
Tom 27
Jane 16
Bill ... 阅读全帖 |
|
d*******1
发帖数: 854 | 39 【 以下文字转载自 Database 讨论区 】
发信人: daydayup1 (咳咳), 信区: Database
标 题: 我的DBA在生成ORACLE table的时候需要一个一个column看
发信站: BBS 未名空间站 (Tue Sep 29 11:36:12 2009, 美东)
我给他一个100 columns的table, 请他生成一个oracle table, 他说要一个一个column
看, 决定data type, 长度什么的, 然后才能load.
真的有这么笨吗? 难道没有什么自动的方式一下子把数据读进去? |
|
l******9
发帖数: 579 | 40 【 以下文字转载自 Database 讨论区 】
发信人: light009 (light009), 信区: Database
标 题: add column name in exporting table netezza aginity sql
发信站: BBS 未名空间站 (Fri Oct 3 01:49:56 2014, 美东)
I need to export a table (60 GB) from IBM netezza aginity sql database
workbench to a csv file.
But, the column names are missing even though I set up "skip row" as 0.
Because the file is too large, I cannot open and edit it in Excel or notepad
/notepad++.
How to add the column names ?
Any help would be appreciated.
thanks |
|
f*******t
发帖数: 7549 | 41 HFile是immutable的。
compaction是把几个HFile合并写入一个临时文件，然后做一个文件系统的transaction
，分三步：
1.把原来的HFile删掉
2.把新的HFile放进column family的文件夹
3.在region里将旧的HFile信息删除，加进新的HFile。
我之前说过了，满足一定条件才会引起flush，加入新的column不会。另外region是按
row key的range分的，跟column没有任何关系。为什么怕region split？ |
|
w**z
发帖数: 8232 | 42 C* is column family, adding new column doesn't mean schema change.
Compaction happens when new data is written to the database and flushed to
the disk as immutable File. So one row could live in different SSTable, in
order to perform the reads more efficiently, compaction needs to be
performed.
It doesn't seem like you understand the fundamental of the column family
based nosql database.
compaction
region |
|
h******o
发帖数: 334 | 43 Java 有一个2D array: int[][] array; 我想把这个2D array的每个column导入到一个
新的1D array, 下面的方法不知道问题在哪里？ 多谢！
int[] column = new int[array.length];
for (int c = 0; c < array[0].length; c++) {
for (int i = 0; i < array.length; i++) {
column[i] = array[i][c];
}
} |
|
T*******n
发帖数: 493 | 44 \usepackage{multicol}
\begin{document}
one column
\begin{multicols}{2}
two column, floats might not work
\end{multicols}
one column, no page break
\end{document} |
|
j****l
发帖数: 3356 | 45 The paper is in double-column format. But the abstract is required
having two-column width (or in one-column mode). The provided cls is
IEEEtran.cls. How to get it?
Thanks a lot! |
|
i*******w
发帖数: 405 | 46 图很宽，所以想让图还是居中占整个Column，可以放在页首或底部，其他文字部分还是
正常的two column 格式，请教怎么弄呢？谢谢！ |
|
c******s
发帖数: 197 | 47 用的ieee的two column格式，有个图片比较大想span two column，用了\begin{figure
*},图片是没有问题了，可是caption却还是one column，这是我的代码，请大家帮忙看
看谢谢
\begin{figure*}[htp]
\centering
\includegraphics[width=12cm,height=5.5cm]{figure/SystemStructures.
pdf}
\caption{Different Hybrid Power System Structures}
\label{fig:1}
\end{figure*} |
|
l*********s
发帖数: 5409 | 48 How to lay out a paper format with one column abstract, two column text and
graphs in Lyx? In addition, \towcolumn command is not good enough since it
starts a new page and waste a lot of white space. |
|
s********a
发帖数: 9 | 49 I have a txt file, with 5 column numbers, for example:
1., 2., 3., 4., 5.,
6., 7., 8., 9., 10.,
11., 12., 13., 14., 15.,
etc. about 1000 rows.
I want to change to one column as
1,
2,
3,
4,
5,
6,
7,
8,
9,
10,
11,
12,
13,
14,
15,
for plotting the numbers.
Could anyone tell me how to do this?
Thanks a lot. |
|
t**s
发帖数: 284 | 50 1. read your txt file into excel. Let's say your data is now in column A to
E, 1000 rows.
2. in column F, from row 1 to 5000, use the following formula:
=INDIRECT(ADDRESS(ROUNDUP(ROW()/5,0),IF((ROW()/5-TRUNC(ROW()/5))*5>0,(ROW()/
5-TRUNC(ROW()/5))*5,5))) |
|
