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!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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... -
How can I query rows for similar /duplicate names
Hi Steve<br> Thanks for your idea.Taking your advice<br> I have re-written my query like below.Even though i am getting duplicates and similiar sounding names, i am still missing names that i know are written in similiar fashion but are in fact duplicate.<br> I also forgot to mention that the... -
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...
