Problem with SELECT DISTINCT Queries
-
Hi all, How to select distinct rows from a table in eVB.I tried this using SELECT DISTINCT Query but it shows error. Can any one help me please... Thanks in Advance Mahesh
-
Hi all, How to select distinct rows from a table in eVB.I tried this using SELECT DISTINCT Query but it shows error. Can any one help me please... Thanks in Advance Mahesh
What DB are you using? Pocket Access does not support SELECT DISTINCT!
-
What DB are you using? Pocket Access does not support SELECT DISTINCT!
hi Paulo, I am using MS Access as database. Can you suggest a solution for this problem. My table contains 5000-10,000 rows of data,out of which i have to select a few distinct rows. regards Mahesh
-
hi Paulo, I am using MS Access as database. Can you suggest a solution for this problem. My table contains 5000-10,000 rows of data,out of which i have to select a few distinct rows. regards Mahesh
You can try working around this problem by creating a separate table, possibly with the same structure, but with an index on the field(s) of your UNIQUE clause. Then copy all the rows from the first table to the second table, making sure that the UNIQUE field(s) does(do) not exist. The index is there to speed up your search. At the end of the procedure, you will have the UNIQUE records. You might want to use this without a separate table, but you would have to create an in-memory array where the UNIQUE fields would be stored, and compared against. If you don't want to do nothing of this, you will have to upgrade to a better database engine, like SQL Server CE 2.0. Good luck! João Paulo