Blogs RSS Blogs RSS Forums RSS Forums RSS
•
•
•
•
Showing results 1 to 5 of 5
Search took 0.00 seconds. Posts Made By: alidabiri
Save these search results for 24 hours
Forum: Oracle Oct 23rd, 2007
Replies: 9
Views: 6,960
Posted By alidabiri
Re: how to select latest or last row in a table

here's the correct answer that i figured out:
SELECT cu.cust_name,
od.order_amount
FROM customers cu,
orders od
WHERE cu.cust_id = od.cust_id
and od.order_date =
...
Forum: Oracle Oct 23rd, 2007
Replies: 9
Views: 6,960
Posted By alidabiri
Re: how to select latest or last row in a table

i want to list all the customer names and then latest date and amount for that date for every customer.
Forum: Oracle Oct 23rd, 2007
Replies: 9
Views: 6,960
Posted By alidabiri
Re: how to select latest or last row in a table

i know about join. how would the code look like, please?
Forum: Oracle Oct 23rd, 2007
Replies: 4
Views: 5,439
Posted By alidabiri
Re: oracle connection from VB.NET 2003

this is what i use with vb and oracle 10g:

strCon = "Driver={Microsoft ODBC for Oracle}; " & _
"CONNECTSTRING=(DESCRIPTION=" & _
"(ADDRESS=(PROTOCOL=TCP)" & _
...
Forum: Oracle Oct 23rd, 2007
Replies: 9
Views: 6,960
Posted By alidabiri
how to select latest or last row in a table

hi,
i have 2 tables: CUST and ORDERS
CUST contains cust_num, cust_name, cust_phone
ORDERS contains cust_num, order_date, order_amt
i want to list all the cust_names and their last order date and...
Showing results 1 to 5 of 5

 
Forums | Blogs | Tutorials | Code Snippets | Whitepapers | RSS Feeds | Advertising
All times are GMT -4. The time now is 12:50 am.
Newsletter Archive - Sitemap - Privacy Statement - Acceptable Use Policy - Contact Us
Forum system based on vBulletin Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC