Hi everyone! I'm new to VB6 and I have a project using a VB6 form to search and display the data from Oracle9i database by press the Search button.
Firstly, I have a database, and a table named FoneDir. The FoneDir include:
Customer_ID; FoneNum; Customer_Name; Customer_Add;
I am writing a from...
I'm working in a telephone company. I'm using Oracle9i, and SQL Navigator for Oracle. Here's my query:
select called, SUM(ceil(duration/60)) as SL0806
from c0806
where called like '1900%' group by called;
The query is fine, but in the results there're many same records like:
A B...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.