Need MySQL query help


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

Veja 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

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

ID do Projeto: #6442919

Concedido a:


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)

27 freelancers estão ofertando em média $18 para esse trabalho


Hi Reid, It seems we collaborated well 11 years ago :) The time gone fast, how are you, how are your business now ? Good lu Mais

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

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)

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)

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

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

A proposal has not yet been provided

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

A proposal has not yet been provided

$20 USD em 1 dia
(22 Comentários)

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)

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)

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)

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)

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)

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)

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

$12 USD in 0 dias
(5 Comentários)

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)

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)

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)

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)

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 [login to view URL] extend our communication in a private chat. Mais

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

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)

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)