PostGreSql Simple Query


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.

Query 1)

This query works on PostGreSLQ

SELECT runner From OddHistoricaPersistente WHERE idMarket = dMarket GROUP BY runner;

Query 2)

This query works in Mysql but does NOT work in PostGreSql

SELECT * From OddHistoricaPersistente WHERE idMarket = idMarket GROUP BY runner

My Problem:

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?

Skills: PostgreSQL

See more: simple machine forum single sign, openx rotation doesnt work php problem, php simple script number hours work, basic simple sample computer repair work order, simple website templates single product, simple machines view single post, tutorial simple web hello name, simple website sell single item, flash websites simple flash game single player, simple formmail php single page, refresh query excel url work vba, postgresql simple postgres trigger python, php simple query mysql, simple xml flash single image viewer, python postgresql select query, I don\ t have any special skill. But I do know Sketching comic book, i can work through electrical appliance, i am good with win, my friends don't support my business, my folks don t want me to talk about slavery pdf, how do i make sure my emails don't go to spam in gmail?, my friends don't listen to my problems

About the Employer:
( 28 reviews ) Belo Horizonte, Brazil

Project ID: #24082828

Awarded to:


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.

$20 USD in 1 day
(1 Review)

7 freelancers are bidding on average $29 for this job


Hi, I am postgresql expert. I can help you to do the required task. Please let us discuss the details. Regards, Mohammad Alaa [login to view URL]

$50 USD in 1 day
(6 Reviews)

Hello how are you, yes i can help you please let me see and i will resolve your problem

$30 USD in 7 days
(4 Reviews)

Hello, i have good experience in postgresql development. i already solved this type of query. please let me know if you interested. thanks.

$35 USD in 1 day
(1 Review)

I can solve this right away.................................................... .........................

$25 USD in 1 day
(1 Review)

Hi, I think it has happened by "Group By" on your postgresql query. As a general form, Group By can be output-column, or input-column, it is little confused or ambiguous. I hope you to discuss more details with me. Tha More

$10 USD in 1 day
(0 Reviews)

Will show you the query you need. Relevant Skills and Experience Python, postgres experience.

$30 USD in 1 day
(0 Reviews)