If you are a PostGreSql expert, this is a trivial project for you. You will make my query in a few minutes.
I am changing the database of a java project from Mysql to PostgreSql.
This query works on PostGreSLQ
SELECT runner From OddHistoricaPersistente WHERE idMarket = dMarket GROUP BY runner;
This query works in Mysql but does NOT work in PostGreSql
SELECT * From OddHistoricaPersistente WHERE idMarket = idMarket GROUP BY runner
I don't want just the runner column from this query. I want all the columns of the table in a single query ("SELECT *" not "SELECT runner")
You can test this query on any PostGreSql database:
"SELECT * FROM table_name GROUP BY column_name;"
As you can see this is a trivia query.
Of course, I can get the runner list, and for each runner to query the entire object with all the columns, but this solution does not interest me.
Can you help me?
Hi there, yes, it is easy. I worked with MySQL and PostgreSQL for a long time so I can do this. Please see my portfolio [login to view URL] Please contact me to discuss more. Regards, Alex.