\n.NET \u3092\u4f7f\u3063\u3066 SQL Server \u306b\u5bfe\u3057\u3066 SELECT \u3059\u308b\u306b\u306f\u3001\u3063\u3066\u3053\u3068\u3067\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306e\u30c1\u30a7\u30c3\u30af\u3092\u3057\u307e\u3057\u305f\u3002\n<\/p>\n
\n\u3068\u3044\u3046\u5f62\u3067\u30c7\u30fc\u30bf\u3092\u4f5c\u3063\u3066\u304a\u3044\u3066\u3001\u4ee5\u4e0b\u306e\u30d1\u30bf\u30fc\u30f3\u3067\u691c\u7d22\u3092\u3057\u307e\u3059\u3002\n<\/p>\n
[code]
\n1.\u500b\u5225SELECT
\n56.5
\n59.3
\n57.5<\/p>\n
2.\u307e\u3068\u3081\u3066SELECT
\n\u203b 1 \u3088\u308a\u9045\u304f\u306a\u3063\u305f\u306e\u3067\u30d1\u30b9<\/p>\n
3.SqlCommand
\n7.6
\n7.5
\n7.4<\/p>\n
4.LINQ to Entities
\n112.5
\n110.6
\n108.2<\/p>\n
5.LINQ to SQL
\n92.4
\n112.3
\n93.9
\n[\/code]<\/p>\n
\n\u7d50\u8ad6\u304b\u3089\u8a00\u3048\u3070\u3001\n<\/p>\n
\n\u3068\u3044\u3046\u7d50\u679c\u306b\u306a\u308a\u307e\u3057\u305f\u3002\n<\/p>\n
\nLINQ \u306e\u5834\u5408\u300110 \u500b\u306e\u30c6\u30fc\u30d6\u30eb\u306b\u5bfe\u3057\u3066\u3001\u691c\u7d22\u3092\u5b9f\u884c\u3059\u308b\u305f\u3081\u306b 10 \u56de\u547c\u3073\u51fa\u3057\u3066\u3057\u307e\u3046\u306e\u3067\u3001\u3053\u306e\u624b\u306e\u65b9\u6cd5\u306f\u4e0d\u5229\u306a\u306e\u3067\u3059\u304c\u3001SqlDataAdapter \u3088\u308a\u3082\u9045\u3044\u306e\u306f\u610f\u5916\u3067\u3059…\u30b9\u30d4\u30fc\u30c9\u304c\u8981\u6c42\u3055\u308c\u308b\u3068\u3053\u308d\u3067\u3001LINQ \u3092\u4f7f\u3046\u306e\u306f\u7981\u7269\u3067\u3059\u306d\u3002\n<\/p>\n
\n\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306e\u30c1\u30e5\u30fc\u30cb\u30f3\u30b0\u3068\u3057\u3066\u306f\u3001SqlCommand \u304c\u4e00\u756a\u3084\u308a\u3084\u3059\u304f\u300110 \u500b\u306e\u30c6\u30fc\u30d6\u30eb\u306b\u5bfe\u3059\u308b SELECT \u3092 1 \u56de\u3067\u6e08\u307e\u305b\u3089\u308c\u308b\u306e\u3082 SQL Server \u3067\u8907\u6570\u306e\u691c\u7d22\u7d50\u679c\uff08DataTable\uff09\u3092\u8fd4\u305b\u308b\u304b\u3089\u3067\u3059\u3002
\n\u307e\u305f\u3001prepared statements \u3068\u3044\u3046\u5f62\u3067\u3001\u3042\u3089\u304b\u3058\u3081 SQL \u6587\u3092\u767a\u884c\u3055\u305b\u3066\u518d\u5229\u7528\u3067\u304d\u308b\u3068\u308d\u3082 SqlCommand \u306e\u6709\u5229\u306a\u3068\u3053\u308d\u3067\u3059\u306d\u3002\n<\/p>\n
\n\u5b9f\u9a13\u30bd\u30fc\u30b9\u3092\u6652\u3057\u3066\u304a\u304d\u307e\u3059\u3002\n<\/p>\n
\n\u25a0\u30c6\u30fc\u30d6\u30eb\u306e\u4f5c\u6210\n<\/p>\n
[code lang=”csharp”]
\n\/\/\/ <summary>
\n\/\/\/ \u30c6\u30fc\u30d6\u30eb\u4f5c\u6210
\n\/\/\/ <\/summary>
\n\/\/\/ <param name="sender"><\/param>
\n\/\/\/ <param name="e"><\/param>
\nprivate void button1_Click(object sender, EventArgs e)
\n{
\n string sql = "";
\n SqlConnection cn = new SqlConnection(CNSTR);
\n cn.Open();
\n SqlCommand cmd;
\n for (int i = 0; i < 10; i++)
\n {
\n sql = string.Format("drop table table{0}", i);
\n cmd = new SqlCommand(sql, cn);
\n try
\n {
\n cmd.ExecuteNonQuery();
\n }
\n catch { }<\/p>\n
sql = string.Format("create table table{0} (", i);
\n for (int j = 0; j < 10; j++)
\n {
\n\t\t\tif (j == 0)
\n\t\t\t{
\n\t\t\t\tsql += string.Format("col{0} varchar(50) not null,", j);
\n\t\t\t}
\n\t\t\telse
\n\t\t\t{
\n\t\t\t\tsql += string.Format("col{0} varchar(50),", j);
\n\t\t\t}
\n }
\n\t\tsql += string.Format(" CONSTRAINT pk_table{0} PRIMARY KEY ( col0 ) ", i );
\n sql += ")";
\n cmd = new SqlCommand(sql, cn);
\n cmd.ExecuteNonQuery();
\n }
\n cn.Close();
\n}
\n[\/code]<\/p>\n
\n\u25a020000\u4ef6\u306e\u30c7\u30fc\u30bf insert\n<\/p>\n
[code lang=”csharp”]
\n\/\/\/ <summary>
\n\/\/\/ \u30c7\u30fc\u30bf\u4f5c\u6210
\n\/\/\/ <\/summary>
\n\/\/\/ <param name="sender"><\/param>
\n\/\/\/ <param name="e"><\/param>
\nprivate void button2_Click(object sender, EventArgs e)
\n{
\n int max = int.Parse(textBox1.Text);
\n SqlConnection cn = new SqlConnection(CNSTR);
\n cn.Open();<\/p>\n
string s = toMD5(DateTime.Now.ToString());
\n int count = 0;
\n for (int i = 0; i < 10; i++)
\n {
\n string sql = string.Format("insert into table{0} values (", i);
\n SqlCommand cmd = new SqlCommand("", cn);
\n for (int k = 0; k < 10; k++)
\n {
\n cmd.Parameters.Add(new SqlParameter(
\n string.Format("@col{0}", k), SqlDbType.VarChar, 50));
\n sql += string.Format("@col{0},", k);
\n }
\n sql = sql.Substring(0, sql.Length – 1);
\n sql += ")";
\n cmd.CommandText = sql;<\/p>\n
for (int j = 0; j < max; j++)
\n {
\n for (int k = 0; k < 10; k++)
\n {
\n s = toMD5(s);
\n cmd.Parameters[k].Value = s;
\n }
\n cmd.ExecuteNonQuery();
\n count++;
\n if (count % 100 == 0)
\n {
\n toStatus(count, max * 10);
\n }
\n }
\n }
\n cn.Close();
\n}
\n[\/code]<\/p>\n
\n\u25a0\u500b\u5225SELECT\n<\/p>\n
\n\u307e\u305a\u3044\u3084\u308a\u65b9\u3067\u3059\u304c\u3001string.Format \u3067\u5024\u8fbc\u307f\u3067\u6587\u5b57\u5217\u3092\u4f5c\u3063\u3066\u3044\u307e\u3059\u3002
\n\u3088\u304f\u3042\u308b\u30d1\u30bf\u30fc\u30f3\u3067\u3059\u306d\u3002\n<\/p>\n
[code lang=”csharp”]
\n\/\/\/ <summary>
\n\/\/\/ \u500b\u5225SELECT
\n\/\/\/ <\/summary>
\n\/\/\/ <param name="sender"><\/param>
\n\/\/\/ <param name="e"><\/param>
\nprivate void button3_Click(object sender, EventArgs e)
\n{
\n \/\/ \u5f8b\u5100\u306bSELECT\u6587\u309210\u56de\u767a\u884c\u3057\u307e\u3059\u3002
\n DateTime start = DateTime.Now;
\n string s = toMD5(start.ToString());
\n int count = 0;
\n SqlConnection cn = new SqlConnection(CNSTR);
\n int max = 2000;
\n for (int i = 0; i < max; i++)
\n {
\n for ( int j=0; j<10; j++ ) {
\n DataTable dt = new DataTable();
\n SqlDataAdapter da = new SqlDataAdapter(
\n string.Format("SELECT * FROM table{0} WHERE col0 = ‘{1}’", j, s), cn);
\n s = toMD5(s);
\n da.Fill( dt );
\n }
\n if (++count % 10 == 0)
\n toStatus(count, max);
\n }
\n DateTime end = DateTime.Now;
\n textBox2.Text = ((TimeSpan)(end – start)).TotalSeconds.ToString("#.0");
\n}
\n[\/code]<\/p>\n
\n\u25a0\u307e\u3068\u3081\u3066SELECT\n<\/p>\n
\nSqlDataAdapter \u306b\u6e21\u3059 SQL \u6587\u3092\u3072\u3068\u307e\u3068\u3081\u306b\u3057\u305f\u306e\u3067\u3059\u304c\u3001\u5168\u7136\u99c4\u76ee\u3067\u3059\u3002\n<\/p>\n
[code lang=”csharp”]
\n\/\/\/ <summary>
\n\/\/\/ \u307e\u3068\u3081\u3066SELECT
\n\/\/\/ <\/summary>
\n\/\/\/ <param name="sender"><\/param>
\n\/\/\/ <param name="e"><\/param>
\n\/\/\/ <remarks>
\n\/\/\/ \u9045\u304f\u3066\u305c\u3093\u305c\u3093\u3060\u3081
\n\/\/\/ <\/remarks>
\nprivate void button4_Click(object sender, EventArgs e)
\n{
\n \/\/ 10\u56de\u306eSELECT\u3092\u3072\u3068\u307e\u3068\u3081\u306b\u3057\u3066 DataSet \u306b\u4fdd\u5b58\u3057\u307e\u3059\u3002
\n DateTime start = DateTime.Now;
\n string s = toMD5(start.ToString());
\n int count = 0;
\n SqlConnection cn = new SqlConnection(CNSTR);
\n string sql = "";
\n int max = 2000;
\n for (int i = 0; i < max; i++)
\n {
\n for (int j = 0; j < 10; j++)
\n {
\n sql += string.Format("SELECT * FROM table{0} WHERE col0 = ‘{1}’ ", j, s);
\n s = toMD5(s);
\n }
\n DataSet ds = new DataSet();
\n SqlDataAdapter da = new SqlDataAdapter(sql, cn);
\n da.Fill(ds);
\n if (++count % 10 == 0)
\n toStatus(count, max );
\n }
\n DateTime end = DateTime.Now;
\n textBox2.Text = ((TimeSpan)(end – start)).TotalSeconds.ToString("#.0");
\n}
\n[\/code]<\/p>\n
\n\u25a0SqlCommand \u3092\u4f7f\u3046\n<\/p>\n
\n\u3042\u3089\u304b\u3058\u3081\u30b3\u30f3\u30d1\u30a4\u30eb\u3055\u308c\u308b\u3088\u3046\u306b SqlCommand \u3092\u4f7f\u3044\u307e\u3059\u3002
\n\u30eb\u30fc\u30d7\u306e\u4e2d\u3067 SqlCommand \u3092\u4f7f\u3063\u3066\u306f\u3044\u3051\u307e\u305b\u3093\u3002\u30eb\u30fc\u30d7\u306e\u5916\u3067\u4f5c\u6210\u3057\u3066\u3001\u30d1\u30e9\u30e1\u30fc\u30bf\u3067\u6e21\u3057\u307e\u3059\u3002
\n[code lang=”csharp”]
\n\/\/\/ <summary>
\n\/\/\/ SqlCommand \u306e\u5229\u7528
\n\/\/\/ <\/summary>
\n\/\/\/ <param name="sender"><\/param>
\n\/\/\/ <param name="e"><\/param>
\nprivate void button5_Click(object sender, EventArgs e)
\n{
\n \/\/ 10\u56de\u306eSELECT\u3092\u3072\u3068\u307e\u3068\u3081\u306b\u3057\u3066 DataSet \u306b\u4fdd\u5b58\u3057\u307e\u3059\u3002
\n DateTime start = DateTime.Now;
\n string s = toMD5(start.ToString());
\n int count = 0;
\n SqlConnection cn = new SqlConnection(CNSTR);
\n string sql = "";
\n<\/p>
\n<p>
\n SqlCommand cmd = new SqlCommand("",cn);
\n for (int j = 0; j < 10; j++)
\n {
\n sql += string.Format("SELECT * FROM table{0} WHERE col0 = @param{1} ", j, j);
\n s = toMD5(s);
\n cmd.Parameters.Add(new SqlParameter(
\n string.Format("@param{0}", j), SqlDbType.VarChar, 50));
\n }
\n cmd.CommandText = sql;
\n<\/p>
\n<p>
\n int max = 2000;
\n for (int i = 0; i < max; i++)
\n {
\n for (int j = 0; j < 10; j++)
\n {
\n cmd.Parameters[j].Value = s;
\n s = toMD5(s);
\n }
\n DataSet ds = new DataSet();
\n SqlDataAdapter da = new SqlDataAdapter(cmd);
\n da.Fill(ds);
\n if (++count % 10 == 0)
\n toStatus(count, max);
\n }
\n DateTime end = DateTime.Now;
\n textBox2.Text = ((TimeSpan)(end – start)).TotalSeconds.ToString("#.0");
\n}
\n[\/code]\n<\/p>\n
\n\u25a0LINQ to Entities\n<\/p>\n
\n\u6bd4\u8f03\u306e\u305f\u3081\u306b LINQ to Entities \u3067\u3082\u4f5c\u3063\u3066\u307f\u307e\u3059\u3002
\nLINQ \u306e\u5834\u5408\u306f\u3001\u8907\u6570\u306e SELECT \u6587\u3092\u307e\u3068\u3081\u308b\u3053\u3068\u304c\u3067\u304d\u306a\u3044\u306e\u3067\u3001\u30eb\u30fc\u30d7\u306e\u4e2d\u3067 10 \u56de\u547c\u3073\u51fa\u3057\u307e\u3059\u3002\u3053\u306e\u65b9\u6cd5\u306f\u3001SqlDataAdapter \u3068\u540c\u3058\u3067\u3059\u3088\u306d\u3002
\n\u30b9\u30d4\u30fc\u30c9\u3092\u6bd4\u8f03\u3057\u305f\u3082\u306e\u304c\u306a\u3044\u306e\u3067\u3001\u521d\u3081\u3066\u8a66\u3057\u3066\u307f\u305f\u306e\u3067\u3059\u304c\u3001\u500b\u5225SELECT\u3088\u308a\u30822\u500d\u307b\u3069\u304a\u305d\u304f\u306a\u308a\u307e\u3059\u3002\n<\/p>\n
[code lang=”csharp”]
\n\/\/\/ <summary>
\n\/\/\/ LINQ to Entities \u306e\u5229\u7528
\n\/\/\/ <\/summary>
\n\/\/\/ <param name="sender"><\/param>
\n\/\/\/ <param name="e"><\/param>
\nprivate void button6_Click(object sender, EventArgs e)
\n{
\n\t\/\/ \u5f8b\u5100\u306bSELECT\u6587\u309210\u56de\u767a\u884c\u3057\u307e\u3059\u3002
\n\tDateTime start = DateTime.Now;
\n\tstring s = toMD5(start.ToString());
\n\tint count = 0;<\/p>\n
\tstressEntities ent = new stressEntities();
\n\tint max = 2000;
\n\tfor (int i = 0; i < max; i++)
\n\t{
\n\t\tvar items0 = from t in ent.table0
\n\t\t\t\t\twhere t.col0 == s
\n\t\t\t\t\tselect t;
\n\t\ts = toMD5(s);
\n\t\tvar item1 = from t in ent.table1
\n\t\t\t\t\t\twhere t.col0 == s
\n\t\t\t\t\t\tselect t;
\n\t\ts = toMD5(s);
\n\t\tvar items2 = from t in ent.table2
\n\t\t\t\t\t\twhere t.col0 == s
\n\t\t\t\t\t\tselect t;
\n\t\ts = toMD5(s);
\n\t\tvar items3 = from t in ent.table3
\n\t\t\t\t\t\twhere t.col0 == s
\n\t\t\t\t\t\tselect t;
\n\t\ts = toMD5(s);
\n\t\tvar items4 = from t in ent.table4
\n\t\t\t\t\t\twhere t.col0 == s
\n\t\t\t\t\t\tselect t;
\n\t\ts = toMD5(s);
\n\t\tvar items5 = from t in ent.table5
\n\t\t\t\t\t\twhere t.col0 == s
\n\t\t\t\t\t\tselect t;
\n\t\ts = toMD5(s);
\n\t\tvar items6 = from t in ent.table6
\n\t\t\t\t\t\twhere t.col0 == s
\n\t\t\t\t\t\tselect t;
\n\t\ts = toMD5(s);
\n\t\tvar items7 = from t in ent.table7
\n\t\t\t\t\t\twhere t.col0 == s
\n\t\t\t\t\t\tselect t;
\n\t\ts = toMD5(s);
\n\t\tvar items8 = from t in ent.table8
\n\t\t\t\t\t\twhere t.col0 == s
\n\t\t\t\t\t\tselect t;
\n\t\ts = toMD5(s);
\n\t\tvar items9 = from t in ent.table9
\n\t\t\t\t\t\twhere t.col0 == s
\n\t\t\t\t\t\tselect t;
\n\t\ts = toMD5(s);<\/p>\n
\t\tvar it0 = items0.SingleOrDefault();
\n\t\tvar it1 = items0.SingleOrDefault();
\n\t\tvar it2 = items0.SingleOrDefault();
\n\t\tvar it3 = items0.SingleOrDefault();
\n\t\tvar it4 = items0.SingleOrDefault();
\n\t\tvar it5 = items0.SingleOrDefault();
\n\t\tvar it6 = items0.SingleOrDefault();
\n\t\tvar it7 = items0.SingleOrDefault();
\n\t\tvar it8 = items0.SingleOrDefault();
\n\t\tvar it9 = items0.SingleOrDefault();<\/p>\n
\t\tif (++count % 10 == 0)
\n\t\t\ttoStatus(count, max);
\n\t}
\n\tDateTime end = DateTime.Now;
\n\ttextBox2.Text = ((TimeSpan)(end – start)).TotalSeconds.ToString("#.0");
\n}
\n[\/code]<\/p>\n
\n\u25a0LINQ to SQL \u3092\u5229\u7528\n<\/p>\n
\n\u6bd4\u8f03\u306e\u305f\u3081\u306b LINQ to SQL \u3067\u3082\u52d5\u304b\u3057\u3066\u307f\u307e\u3059\u3002
\n\u4e0d\u5229\u306a\u306e\u306f\u3001LINQ to Entities \u3068\u540c\u3058\u3067\u300110 \u56de\u547c\u3073\u51fa\u3055\u306a\u3044\u3068\u3044\u3051\u306a\u3044\u3068\u3053\u308d\u3067\u3059\u306d\u3002
\n\u30b9\u30d4\u30fc\u30c9\u306b\u95a2\u3057\u3066\u306f\u3001LINQ to Entities \u3068\u5909\u308f\u308a\u307e\u305b\u3093\u3002\n<\/p>\n
[code lang=”csharp”]
\n\/\/\/ <summary>
\n\/\/\/ LINQ to SQL \u306e\u5229\u7528
\n\/\/\/ <\/summary>
\n\/\/\/ <param name="sender"><\/param>
\n\/\/\/ <param name="e"><\/param>
\nprivate void button7_Click(object sender, EventArgs e)
\n{
\n\t\/\/ \u5f8b\u5100\u306bSELECT\u6587\u309210\u56de\u767a\u884c\u3057\u307e\u3059\u3002
\n\tDateTime start = DateTime.Now;
\n\tstring s = toMD5(start.ToString());
\n\tint count = 0;<\/p>\n
SqlConnection cn = new SqlConnection(CNSTR);
\n\tDataClasses1DataContext cnt = new DataClasses1DataContext(cn);<\/p>\n
\tint max = 2000;
\n\tfor (int i = 0; i < max; i++)
\n\t{
\n\t\tvar items0 = from t in cnt.Dtable0
\n\t\t\t\t\t\twhere t.col0 == s
\n\t\t\t\t\t\tselect t;
\n\t\ts = toMD5(s);
\n\t\tvar item1 = from t in cnt.Dtable1
\n\t\t\t\t\twhere t.col0 == s
\n\t\t\t\t\tselect t;
\n\t\ts = toMD5(s);
\n\t\tvar items2 = from t in cnt.Dtable2
\n\t\t\t\t\t\twhere t.col0 == s
\n\t\t\t\t\t\tselect t;
\n\t\ts = toMD5(s);
\n\t\tvar items3 = from t in cnt.Dtable3
\n\t\t\t\t\t\twhere t.col0 == s
\n\t\t\t\t\t\tselect t;
\n\t\ts = toMD5(s);
\n\t\tvar items4 = from t in cnt.Dtable4
\n\t\t\t\t\t\twhere t.col0 == s
\n\t\t\t\t\t\tselect t;
\n\t\ts = toMD5(s);
\n\t\tvar items5 = from t in cnt.Dtable5
\n\t\t\t\t\t\twhere t.col0 == s
\n\t\t\t\t\t\tselect t;
\n\t\ts = toMD5(s);
\n\t\tvar items6 = from t in cnt.Dtable6
\n\t\t\t\t\t\twhere t.col0 == s
\n\t\t\t\t\t\tselect t;
\n\t\ts = toMD5(s);
\n\t\tvar items7 = from t in cnt.Dtable7
\n\t\t\t\t\t\twhere t.col0 == s
\n\t\t\t\t\t\tselect t;
\n\t\ts = toMD5(s);
\n\t\tvar items8 = from t in cnt.Dtable8
\n\t\t\t\t\t\twhere t.col0 == s
\n\t\t\t\t\t\tselect t;
\n\t\ts = toMD5(s);
\n\t\tvar items9 = from t in cnt.Dtable9
\n\t\t\t\t\t\twhere t.col0 == s
\n\t\t\t\t\t\tselect t;
\n\t\ts = toMD5(s);<\/p>\n
\t\tvar it0 = items0.SingleOrDefault();
\n\t\tvar it1 = items0.SingleOrDefault();
\n\t\tvar it2 = items0.SingleOrDefault();
\n\t\tvar it3 = items0.SingleOrDefault();
\n\t\tvar it4 = items0.SingleOrDefault();
\n\t\tvar it5 = items0.SingleOrDefault();
\n\t\tvar it6 = items0.SingleOrDefault();
\n\t\tvar it7 = items0.SingleOrDefault();
\n\t\tvar it8 = items0.SingleOrDefault();
\n\t\tvar it9 = items0.SingleOrDefault();<\/p>\n
\t\tif (++count % 10 == 0)
\n\t\t\ttoStatus(count, max);
\n\t}
\n\tDateTime end = DateTime.Now;
\n\ttextBox2.Text = ((TimeSpan)(end – start)).TotalSeconds.ToString("#.0");
\n}
\n[\/code]<\/p>\n
\n\u305d\u3093\u306a\u8a33\u3067\u3001\u5b9f\u884c\u6642\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u304c\u6c17\u306b\u304b\u304b\u308b\u5834\u5408\u306f\u3001SqlCommand \u306b\u3059\u308b\u3068 10 \u500d\u307b\u3069\u65e9\u304f\u306a\u308b\u3088\u3001\u3068\u3044\u3046\u8a71\u3067\u3059\u3002\u9006\u306b\u8a00\u3048\u3070\u3001\u305f\u3044\u3057\u3066\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u304c\u6c17\u306b\u306a\u3089\u306a\u3044\u3068\u304d\u306f\u3001\u66f8\u304d\u3084\u3059\u3044 LINQ \u3092\u4f7f\u3063\u305f\u307b\u3046\u304c\u3088\u3044\u3067\u3057\u3087\u3046\u3063\u3066\u3053\u3068\u3067\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
.NET \u3092\u4f7f\u3063\u3066 SQL Server \u306b\u5bfe\u3057\u3066 SELECT \u3059\u308b\u306b\u306f\u3001\u3063\u3066\u3053\u3068\u3067\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306e\u30c1\u30a7\u30c3\u30af\u3092\u3057\u307e\u3057\u305f\u3002 10 \u500b\u306e\u30c6\u30fc\u30d6\u30eb\u306b 20000 \u4ef6\u305a\u3064\u30c7\u30fc\u30bf\u3092\u5165\u308c\u3066\u304a\u304d\u307e\u3059\u3002 10 \u500b\u306e\u30c6\u30fc\u30d6\u30eb\u306b\u5bfe\u3057\u3066\u30012 … \u7d9a\u304d\u3092\u8aad\u3080