Selecting Unique Rows
Posted: Fri Oct 13, 2006 2:35 pm
Hi,
Just a quick question. I need to select some information in my database to list out fleet names (which each row has a fleet name), but there are many repetitions. For example, I have three rows for three different airplanes. Two of them are in fleet A and the last in fleet B. Each row is labled which fleet it is in. However, I need to get just the unique fleet names. So when I search that DB, I get back just the names fleet A and fleet B.
any help is appreciated!
Thanks,
- Jeff
Just a quick question. I need to select some information in my database to list out fleet names (which each row has a fleet name), but there are many repetitions. For example, I have three rows for three different airplanes. Two of them are in fleet A and the last in fleet B. Each row is labled which fleet it is in. However, I need to get just the unique fleet names. So when I search that DB, I get back just the names fleet A and fleet B.
any help is appreciated!
Thanks,
- Jeff