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..

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

      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...

        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.

          thank you ...

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

          thanks..

            Write a Reply...