# Query

**URL:** <https://www.ruby-forum.com/t/query/189687>\
**Category:** Rails\
**Created:** [June 5, 2010, 10:43am UTC](https://www.ruby-forum.com/t/query/189687 "2010-06-05T10:43:04Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Srinivas\_G](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/48db29/32.png) [@Srinivas\_G](https://www.ruby-forum.com/u/Srinivas_G)\
**Post date:** [June 5, 2010, 10:43am UTC](https://www.ruby-forum.com/t/query/189687/1 "2010-06-05T10:43:04Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Srinivas\_G](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/48db29/32.png) [@Srinivas\_G](https://www.ruby-forum.com/u/Srinivas_G)\
**Post date:** [June 5, 2010, 7:27pm UTC](https://www.ruby-forum.com/t/query/189687/2 "2010-06-05T19:27:15Z")

</div>

> 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

---

<div class="post-metadata">

**Author:** ![Srinivas\_G](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/48db29/32.png) [@Srinivas\_G](https://www.ruby-forum.com/u/Srinivas_G)\
**Post date:** [June 5, 2010, 9:30pm UTC](https://www.ruby-forum.com/t/query/189687/3 "2010-06-05T21:30:58Z")

</div>

Thank You Sijo

---

<div class="post-metadata">

**Author:** ![Srinivas\_G](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/48db29/32.png) [@Srinivas\_G](https://www.ruby-forum.com/u/Srinivas_G)\
**Post date:** [June 6, 2010, 7:35am UTC](https://www.ruby-forum.com/t/query/189687/4 "2010-06-06T07:35:20Z")

</div>

Srinivas G. 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](http://www.marnen.org)  
removed\_email\_address@domain.invalid

---

<div class="post-metadata">

**Author:** ![Srinivas\_G](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/48db29/32.png) [@Srinivas\_G](https://www.ruby-forum.com/u/Srinivas_G)\
**Post date:** [June 6, 2010, 11:49am UTC](https://www.ruby-forum.com/t/query/189687/5 "2010-06-06T11:49:34Z")

</div>

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

On Sat, Jun 5, 2010 at 3:29 PM, Srinivas G.  
[removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)wrote:

> > Sijo  
> > .  
> > For more options, visit this group at  
> > [http://groups.google.com/group/rubyonrails-talk?hl=en](http://groups.google.com/group/rubyonrails-talk?hl=en).

–  
Sanjay Sarachandrakumaran

Follow me  
[http://www.twitter.com/ssarachandra](http://www.twitter.com/ssarachandra)

> **[Log into Facebook](https://www.facebook.com/ssarachandra)**
>
> Log into Facebook to start sharing and connecting with your friends, family, and people you know.

---

<div class="post-metadata">

**Author:** ![Srinivas\_G](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/48db29/32.png) [@Srinivas\_G](https://www.ruby-forum.com/u/Srinivas_G)\
**Post date:** [June 6, 2010, 11:52pm UTC](https://www.ruby-forum.com/t/query/189687/6 "2010-06-06T23:52:26Z")

</div>

Ar Chron wrote:

> Srinivas G. 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](http://www.marnen.org)  
removed\_email\_address@domain.invalid

---

<div class="post-metadata">

**Author:** ![Srinivas\_G](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/48db29/32.png) [@Srinivas\_G](https://www.ruby-forum.com/u/Srinivas_G)\
**Post date:** [June 6, 2010, 7:44pm UTC](https://www.ruby-forum.com/t/query/189687/7 "2010-06-06T19:44:56Z")

</div>

Srinivas G. 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