query

[Srinivas Golyalla]

‘Teacher’ is a table in a database. Based on that information,
explain what the following query is searching for in the table:
Teacher.find(:all, :condition => { :grade => 9..12})

[Sijo k g]

> Teacher.find(:all, :condition => { :grade => 9..12})

This means getting all records from teacher table teachers where
column grade has value between 9 & 12.

select * from teachers where grade between 9 and 12

Sijo

--
Posted via http://www.ruby-forum.com/.

[Srinivas Golyalla]

Thank You Sijo

[Marnen Laibow-Koser]

Srinivas Golyalla wrote:
> �Teacher� is a table in a database. Based on that information,

> explain what the following query is searching for in the table:
> Teacher.find(:all, :condition => { :grade => 9..12})

Do your own homework.

Best,
--
Marnen Laibow-Koser
http://www.marnen.org
mar...@marnen.org

[Sanjay Sarachandrakumaran]

It would be a better practice to include all column names in the Select instead of *

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonra...@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-ta...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.

--
Sanjay Sarachandrakumaran

Follow me
http://www.twitter.com/ssarachandra
http://www.facebook.com/ssarachandra

[Ar Chron]

Srinivas Golyalla wrote:
> �Teacher� is a table in a database. Based on that information,

> explain what the following query is searching for in the table:
> Teacher.find(:all, :condition => { :grade => 9..12})

this query returns an uneducated student named srinivas

[Marnen Laibow-Koser]

Ar Chron wrote:
> Srinivas Golyalla wrote:
>> �Teacher� is a table in a database. Based on that information,
>> explain what the following query is searching for in the table:
>> Teacher.find(:all, :condition => { :grade => 9..12})
>
> this query returns an uneducated student named srinivas

Well said!

Best,
--
Marnen Laibow-Koser
http://www.marnen.org
mar...@marnen.org