ST Alpha - "Can't you set it up as an outer query?" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Login
Create Account

Search Dr. S. Talk
TT/ST Wiki
How Well Do You Know ...

RSS Feed

Hosting by DigitalOcean

Support ST on Ko-Fi

Down to Post

Backboards:

Posts: 155

In response to "eh ... the number of replies is calculated dynamically, so the subqueries for that would cripple the database -- nm" by Beryllium

Can't you set it up as an outer query?

Posted by GregW (aka not2fast) Jul 20 '12, 13:43

Select from ( main select ) where count(replies) > 5

Responses:

go back to your DB2 world - zork Jul 20, 13:48 3
- Gladly. My company just bought another company that has a MySQL database. Fortunately, my work is just converting it. -- nm - GregW Jul 20, 13:53 2
  - we use MS here -- nm - zork Jul 20, 13:56 1
    - although most of my work is non-db but crunching fixed column or card format flat ascii files. -- nm - zork Jul 20, 14:01
replies are recursive. MySQL is not ... friendly ... to recursion or nested sets. -- nm - Beryllium Jul 20, 13:45

Post a message top

Replies are disabled on threads older than 7 days.