I have a table similar with this one link
Is it possible to display the ID only once? So the expected result will be a table with 2 rows, but the id wont be displayed twice, only once.
I didn't write any code because I dont know where to start from.
Asked
Active
Viewed 73 times
0
-
What is the primary key of your table? – SLFl May 16 '16 at 21:50
-
I don't have a primary key for this table. It's supposed to be a table where i register all the logins made by POST_ID. – Tedy Grey May 16 '16 at 21:56
-
Thank you for suggesting that possible duplicate! :) – Tedy Grey May 16 '16 at 22:04
-
I would suggest you to create a trigger that after inserting in your table verifies POST_ID and if already exists replaces that row (to store the last login) – SLFl May 16 '16 at 22:13
-
I don't want to replace the duplicates, i want to display all of them, but id don't want to display each time the id. – Tedy Grey May 16 '16 at 22:17
-
So, in that example what you want is a row with ID = 1 and the other one with a blank ID? – SLFl May 17 '16 at 09:42
-
Exactly. That's what I want. – Tedy Grey May 17 '16 at 17:11
-
In that case you can always use a trigger that when a row is inserted, if that POST_ID is already displayed you update that row and set the value that you want to display (in this case: `SET column = ''`) – SLFl May 17 '16 at 20:31
-
Thank you, I will try it that way. – Tedy Grey May 18 '16 at 19:46