title: SQL Selecting all rows except the column with the highest value
body: <p>Here's my table(blog) with all the output shown via SELECT *</p>
  
  <p>I'm trying to select all execpt the highest value in the blogid column</p>
  
  <p>I tried using:</p>
  
  <pre><code>SELECT *
  FROM blog
  WHERE blogid &lt; MAX(blogid) 
  ORDER BY createddate DESC
  </code></pre>
  
  <p>where I hoped it selects all values that is below the max number in blogid but this gets a error "Invalid use of group function".</p>
  
  <p>any help will be appreciated</p>
  
  <p><a href="https://i.stack.imgur.com/qOp5k.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/qOp5k.png" alt="enter image description here"></a></p>