MSAccess aggregate and MySql

[brilliants]

hiiiiiii

is there ny way to get the same result of using the Aggregate FIRST - which is used in MSAccess- in MySQL , if so .. pleassse provide a small example...or a referance..

thanks indeed..

[Lars_Berg]

No. Min/max is what you can use. First or last are not relational concepts.

[brilliants]

thanks for your kind information

oo 🙁

is there ny wrorkround to get the same results..

what i know is that Min and Max is to get the minimum or maximum of a number .. but waht bout string fields.. i guess there should be some way!.. to get the first or the last entry ...

pleeeeese help 😕

thnaks indeeed...

[Lars_Berg]

A dbms does not keep track of in which order the data is entered into a table. If you need this you must have a datetime field that containts the time when the post was inserted.

In mysql you can do this by using the function current_timestamp in your insert statement.

[brilliants]

thank you ...

guess i have to approch d soulistion in nother way...

thanks..