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 bkrike 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: *

  • Users: hu
  • Content: Threads
  • Order by date
  1. hu

    How to get the max values?

    I have a table like this Fruits ------- Apples |Oranges | Bananas 0 | 1 | 0 0 | 1 | 5 0 | 0 | 2 0 | 0 | 1 1 | 2 | 1 1 | 1 | 1 1 | 3 | 6 I need to get the row that points to the max of oranges and Bananas group...
    • hu
    • Thread
    • Replies: 3
    • Forum: ANSI_SQL
  2. hu

    How can I query rows for similar /duplicate names

    Hi<br> I am trying to run a query that will return rows which are actually duplicate but entered in the database in a different format.<br> For eg:<br> David Whitter R<br> David R Whitter<br> I used the soundex function , but did not return rows as expected.<br> It returned only duplicate...
    • hu
    • Thread
    • Replies: 5
    • Forum: ANSI_SQL

Part and Inventory Search

Back
Top