query

rubyonrails-talk
1

‘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})

2

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

3

Thank You Sijo

4

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

5

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,

6

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

7

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,