DaniWeb Forum Index > Search Forums

Search Results

•

Showing results 1 to 2 of 2
Search took 0.00 seconds. Search: Posts Made By: jbisono ; Forum: MySQL and child forums

Save these search results for 24 hours

Forum: MySQL

Oct 2nd, 2009

Replies: 3

retrieve the last record???

Views: 509

Posted By jbisono

Re: retrieve the last record???

I do not know if this can help you, but if you have a date field which you can order by desc, then you can use Top 1 something like this.

Select top 1 Field1
from table1
order by datefield desc...

Forum: MySQL

Jun 23rd, 2009

Replies: 9

Solved: Getting data from multiple table issue

Views: 717

Posted By jbisono

Re: Getting data from multiple table issue

ok so your statement should be like this.
regards.

Showing results 1 to 2 of 2