>>250
#!/usr/bin/ruby
require "dbi"
DBI.connect("dbi:Mysql:test:localhost", "root", "password") do |dbh|
　dbh.execute("SELECT * FROM tbl_employee WHERE dpt_code <> 10") do |sth|
　　puts sth.fetch_all.select{|row| row[0] == 104}.join("¥n")
　end
end