Post reply

Divide by

  • November 3, 2010 at 4:29 am

    #225754

    How do i get the following script to divide by eight?

    SELECT COUNT(*)

    FROM myTable

    WHERE Class = 'Art'

    The result returns me 499, i want this figures to by divided by 8

    so 499/8 = 62

    I've tried this but it doesn't work...

    SELECT *

    (SELECT COUNT(*)

    FROM myTable

    WHERE Class = 'Art'

    )/8

  • November 3, 2010 at 4:31 am

    #1245898

    ummmm

    SELECT COUNT(*)/8

    FROM myTable

    WHERE Class = 'Art'


    Clear Sky SQL
    My Blog[/url]

  • November 3, 2010 at 4:47 am

    #1245908

    thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply