Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Hello!

Author  Topic 

Zajcica
Starting Member

22 Posts

Posted - 2013-05-07 : 04:42:44
Please, I have next entities: (girls read books in the library)

girls(ID, ...)
school(ID, ...)
book(ID, ...)

I have to make a kind of program in sql, for the book ID=3, from which school are most readers?

Please, if any suggestions- i try but get many mistakes in oracle (tried with Limit1, max, but no success...)
Many thanks!

ahmeds08
Aged Yak Warrior

737 Posts

Posted - 2013-05-07 : 05:11:09
someone with plsql experience may help you.
This is Microsoft sql server forum.

mohammad.javeed.ahmed@gmail.com
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-05-07 : 06:05:44
you've not specfied how they're related. Which table will relate books against girls who read them?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
   

- Advertisement -