Terminé

PostgreSQL Query Table Comparison

I have a table called "proxies" that has a "proxy" column and a "port" column

I have another table called "accounts" that also has a "proxy" column and a "port" column

The difference between them is the "accounts" table may have the same proxy listed many times while the "proxies" table will only have the proxy listed once.

I need a PostgreSQL statement that will do the following

1. check the proxies listed in the "proxies" table with the proxies listed in the "accounts" table and return the proxy & ports of all the proxies in the "proxies" table that are listed less than 10 times in the "accounts" table.

Compétences : PostgreSQL

en voir plus : need check phone number, sql parent child table query, folder tree table query, finantial statement need, parent child table query, drop select table query, need check some1 text, stored procedure parent child table query, need check credibility shopping website

Concernant l'employeur :
( 57 commentaires ) Arlington, United States

Nº du projet : #8097837

Décerné à:

manishsethis

Hi I have understood the requirement and i think i can create a postgresql command for it. I have been working on different database such as MYSQL, Postgresql etc Contact me and will get it done immediately.

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(1 Évaluation)
1.0

3 freelance font une offre moyenne de $27 pour ce travail

danilogbotelho

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(0 Commentaires)
0.0
aoden

A proposal has not yet been provided

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0