I have a table that belongs to a person's cell phone texting called 'Ali'. He received text messages from people and sent his text message reply to those people.

MessageTable looks like this:

I want the table to be arranged in such a way that, firstly, all the text messages that Ali had with each person are arranged separately, and secondly, the date and time are displayed in order. something like this:

I need SQL code, Can every body help me?

CodePudding user response：

Create a calculated column with a CASE statement that sets its value to the sender if the receiver is Ali and to the receiver if the sender is Ali.

Sort by this column and the date

CodePudding user response：

I come from Java. I do not use SQL. But I had a similar problem a while ago and I will just explain how I solved it: I created an ArrayList of Objects of the type of Class. In Your case these would the the calls, or messages. These objects have specific data. I then would use a model to add data in the list and change the model, not the list. I would then create an 2D array of Strings that contain the Data. When you change the data, you just rearrange the way the 2D Array is created. Also use a loop to create the 2D Array so your list can be infinitly big. I used all the trigger words. You may want to do the research on how to do it with SQL yourself. If it does help, let me know.