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:
( 217 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
(1 Comentário)
0.6

27 freelancers are bidding on average $18 for this job

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
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
(58 Comentários)
5.8
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
(87 Comentários)
6.2
amcorreia

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

$30 USD em 1 dia
(39 Comentários)
5.5
froiden07

A proposal has not yet been provided

$14 USD in 0 dias
(77 Comentários)
6.2
aneeshtclt

A proposal has not yet been provided

$20 USD em 1 dia
(22 Comentários)
5.2
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
(14 Comentários)
4.3
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
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
(7 Comentários)
4.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
(2 Comentários)
3.6
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
(8 Comentários)
3.9
anuramafl

i have the 4+ year experience in PHP and MYSql. i will finish this with in the 3 to 4 hours with full test.

$10 USD in 0 dias
(4 Comentários)
3.3
sgiant

Sir, i can write this query for you . Though i am new here, i have 7+ years experience in [url removed, login to view] to work on your [url removed, login to view] can be done efficiently . waiting for your response with some more details Mais

$12 USD in 0 dias
(5 Comentários)
2.5
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
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
(2 Comentários)
1.7
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
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
shitaljc

Hi Sir/Madam, I have multiple innovative ideas for your project and I assure that I can give you more than expected for your project work and meet your [url removed, login to view] extend our communication in a private chat. Mais

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

I could modify your queries to get the required result. I have 2 to 3 year of working experience in PHP & MySQL, so I could easily solve your problem or debug your queries provided some sample examples. I could finish Mais

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

hello there, i am interested to take your bid. i can help you to solve the problem ,since i am quite efficient at MYSQL, thank you yours sincerely and please if you accept my bid, do upload sceen shots of yo Mais

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