Divide by

• akhlaq768

  SSChasing Mays

  Points: 642

  More actions

  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

• Dave Ballantyne

  SSC-Dedicated

  Points: 33667

  More actions

  November 3, 2010 at 4:31 am

  #1245898

  ummmm

  SELECT COUNT(*)/8

  FROM myTable

  WHERE Class = 'Art'

  ---

  
  Clear Sky SQL
  My Blog[/url]

• akhlaq768

  SSChasing Mays

  Points: 642

  More actions

  November 3, 2010 at 4:47 am

  #1245908

  thanks