Hi all,Im afraid if iam posting this query in a wrong area,I have a problem and i need urgent answer to this ...
I have a windows application which displays tables of customers...i need to implement a feature that displays all the ID's of customers...as soon as the customer ID is entered.
For example if we search contacts in the nokia phones,we get instantaneous results..
Hope everyone here got it and atleast have an idea of how to implement it..Plz help and thanks in advance..
Bechir BejaouiPosted Mar 21, 2008, 9:19 AM
Select * From Customers
GroupBy ID
Having ID = Max(ID)
Else if the ID is not auto increment field then a new Field into your Table and set it auto increment. Then apply the above query using this new fied instead of the ID