Em Andamento

Need MySQL query help

MYSQL

I need help with a MySQL query (on the WHERE clause). Currently I have:

SELECT UniqueId, CompanyName, City, JobCategory, JobTitle, InfoUrl FROM `jobads` WHERE `JobCatory` = 'sales'

I want to only select results where there are at least 4 unique JobTitles for the CompanyName.

In other words, in the above example, I want the query to disregard companies that don't have at least 4 different types of sales jobs.

When you post your bid, please let me know how long it will take for you to complete the work.

Thanks for reading!

Habilidades: MySQL

Ver mais: unique sales jobs, types of sales jobs, post sales jobs, only sales jobs, different types of sales jobs, different types of jobs, different sales jobs, companies sales jobs, at&t sales jobs, it sales jobs, mysql query, work sales need help, mysql query example, sales jobs, select select mysql, post mysql query, complete mysql example, select mysql example, different types blouses, different types design patterns dot net, different types accounts can create youtube, pictures different types shirt blouse sleeves, types jobs can expert effects, pictures different types shirts, writers different types sites

Acerca do Empregador:
( 216 comentários ) San Francisco, United States

ID do Projeto: #6442919

Premiar a:

whq4557

Hello,you can test the SQL SELECT JobTitle, MAX(CompanyName) FROM `jobads` GROUP BY jobtitle HAVING COUNT(*) > 3 if it not, I can try it again.

$10 USD em 1 dia
(0 Avaliações)
0.0

28 freelancers estão ofertando em média $19 para este trabalho

atufa

Hi Reid, It seems we collaborated well 11 years ago :) [url removed, login to view] The time gone fast, how are you, how are your business now ? Good lu Mais

$20 USD em 1 dia
(65 Comentários)
6.0
froiden07

A proposal has not yet been provided

$14 USD in 0 dias
(70 Comentários)
6.0
truongnguyen86

Hi there, i'm expert on mysql, pls share your table script, i think should take at maximum 1 hour. Waiting for your feedback. Thank you

$35 USD in 0 dias
(16 Comentários)
4.3
aneeshtclt

A proposal has not yet been provided

$20 USD em 1 dia
(12 Comentários)
4.3
ssplancer

Dear Sir, I can provide you the best solution immediately. I'm expert in database, query writing and optimization. Regards, ssplancer

$10 USD in 0 dias
(8 Comentários)
4.1
shennz

HI, Ready to start............ Please PM me for more details............................................................... I can finish this task within a few hours Thank You

$20 USD in 0 dias
(4 Comentários)
3.8
djain01

Hello, I have more than 13 years of programming experience with Windows and Web Applications. I am well-versed with the Microsoft Technology. Proficient in programming with VB6, VB and C#.Net and different databases Mais

$30 USD em 1 dia
(9 Comentários)
3.7
amcorreia

Hi, give me an example of your table and then in 2 hours i solve this. .

$30 USD em 1 dia
(13 Comentários)
3.4
carivera

Hello, I can complete this query in about an hour. I have great proven experience working with complex mysql queries. Looking forward to your positive response. Regards,

$30 USD in 0 dias
(5 Comentários)
3.1
HDragon131

Hi Dear! I am a Expert of skills such as php, mysql, html5 and web site management. Also i have a lot of experience with these skill. I am familiar with the functions you mention in the description.I am very muc Mais

$20 USD em 1 dia
(2 Comentários)
2.3
swagatab

Hello, I have the query ready. I can pass it on right now once you accept my proposal. Regards, Swagata

$15 USD em 1 dia
(1 Comentário)
2.0
avinashjain09

Give me your tables I will create the query and give to you without awarding me the project. I will require hardly one hour that also because i don't know your database structure , you need to apply a count function he Mais

$20 USD em 1 dia
(6 Comentários)
1.9
Shyamrk

Hello, I am a software engineering student and on my vacation. I just want to earn some money and so applying to your project. Though I am a new freelancer but still I can complete your project because I have Mais

$15 USD em 1 dia
(0 Comentários)
0.0
haribj5

I understood the compelete requirement of our need and i Have experience of about 2 yrs in query optimization..

$15 USD em 1 dia
(0 Comentários)
0.0
nojnish

Hi, I can help you with this. is companyName,JobTitle combination unique in table jobads? hope to complete within a day if clarifications are provided quickly. regards Babu

$25 USD in 2 dias
(0 Comentários)
0.0
sunaiddetho

Your Required Structural Queries and Also PHP Code integration with MYSQL to Connect and Create Databases and Tables from PHP File and SQL Query... may be given in a few minutes...

$20 USD em 1 dia
(0 Comentários)
0.0
WrongName

I am using MySQL for a long time now, I know how to write complex queries, and I've already been confronted to your problem. Regards, Florent

$15 USD in 2 dias
(0 Comentários)
0.0
naeemchannar

1 to 2 hour Working process and availability I available to work up to 8 hours a day through 6 days a week (up to 35 hr/week). My timezone is GMT+5. I'm online in Skype 8-20GMT. I usually reply to emails within Mais

$20 USD em 1 dia
(0 Comentários)
0.0
webstylo

I am familiar with the functionality you mention in the description. I'll provide you the work as per your requirement with in a particular time frame. Thanks.

$10 USD em 1 dia
(0 Comentários)
0.0
CardoAda

Hi their, It would only take around 30 mins - an hour to sort depending on how its coded ( PDO, MySql, MySqli etc) Many thanks, Adam

$15 USD em 1 dia
(0 Comentários)
0.0