Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. nariman

    [MySQL] SUBSELECT & MAX()

    SELECT * FROM table WHERE row_id != MAX(row_id) This wont work, because you cant use MAX() in the WHERE-row. Anyone else? Plzzzzzzz !!!
  2. nariman

    [MySQL] SUBSELECT & MAX()

    Hi people, I’m working with MySQL and I want to select all rows of the table except the last one. In ANSI SQL dialect I would use the following query: SELECT * FROM table WHERE row_id != (SELECT MAX(row_id) FROM table) But I have to rewrite it for MySQL. Can someone plz help me?

Part and Inventory Search

Back
Top