MySQL Forums
Forum List  »  Newbie

Read a table in different sequences
Posted by: Mike Lambert
Date: March 10, 2020 03:33AM

Hi,

I have a table with 3 columns A B C

I would like to access the table via column A in ascending sequence.

Then access the table via Column B and A both in descending sequence.

Then access C and A with C in descending and A in ascending sequences

If possible I would like to have these 'views' updated dynamically as data is added to the table.

Thanks,

Mike

Options: ReplyQuote


Subject
Written By
Posted
Read a table in different sequences
March 10, 2020 03:33AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.