Find Jobs
Hire Freelancers

Create a User defined functions (UDF) on MYSQL

$10-30 USD

Abgesagt
Veröffentlicht vor etwa 7 Jahren

$10-30 USD

Bezahlt bei Lieferung
I have a query that run over MYSQL and i need to create a User defined functions (UDF) to optimize my work. the query runs over two tables: repository_clinicaltrial and repository_institution ###Query select distinct state as estado, (select count(id) from repository_clinicaltrial where primary_sponsor_id in (select id from repository_institution where state = estado)) as qty, (select count(id) from repository_clinicaltrial where primary_sponsor_id in (select id from repository_institution where state = estado) and is_observational = 1) as observacional, (select count(id) from repository_clinicaltrial where primary_sponsor_id in (select id from repository_institution where state = estado) and is_observational = 0) as intervencional, (select count(id) from repository_clinicaltrial where primary_sponsor_id in (select id from repository_institution where state = estado) and trial_id like "RBR%") as aprovados from repository_institution order by qty desc;
Projekt-ID: 13886003

Über das Projekt

13 Vorschläge
Remote Projekt
Aktiv vor 7 Jahren

Möchten Sie etwas Geld verdienen?

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten
13 Freelancer bieten im Durchschnitt $39 USD für diesen Auftrag
Avatar des Nutzers
I am very proficient in c and c++. I have 16 years c++ developing experience now, and have worked for more than 7 years. My work is online game developing, and mainly focus on server side, using c++ under Linux environment. I made many great projects using c++, for example, I made the tools which could convert java codes into c++ scripts, of course garbage collection included, this was very similar to a compiler, and was very complex. I also made our own mobile game using c++, I can show you the demo of client, if you like. I am very proficient in java also. I have a very good review on Freelancer.com, I never miss a project once I accept the job, you can check my review. Trust me, please let expert help you.
$100 USD in 1 Tag
4,9 (98 Bewertungen)
6,8
6,8
Avatar des Nutzers
Hi, I am an experienced developer with vast experience in .NET, MVC and SQL available for this project. I am full time freelancer available 10 hours daily. Thanks and best regards Khalid
$35 USD in 1 Tag
4,9 (23 Bewertungen)
5,2
5,2
Avatar des Nutzers
Hello There, I think I can help you out to achieve this task. Please provide the details over PM. Thanks,
$35 USD in 1 Tag
5,0 (32 Bewertungen)
5,2
5,2
Avatar des Nutzers
Hi, I'm SQL developer with 3+ years of professional work experience. Why do you think that UDF functions would optimize your code.?They would just make it more readable, but not necessarily faster. Please, feel free to contact me. Best regards, Alen
$10 USD in 1 Tag
5,0 (1 Bewertung)
0,3
0,3
Avatar des Nutzers
Hello Sir/Madam, I am having around 13 years of experience in mobile & .NET technologies(C#/VB). I am expert in asp.net MVC, Cordova, Xamarin, Android, IPhone, Web API, asp.net, WPF, AngularJs, TypeScript, ExtJS, YUI, JQuery, Bootstrapper frameworks. I have gone through your requirement & it exactly match with my skills. Looking forward a positive response from your end
$55 USD in 1 Tag
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
A proposal has not yet been provided
$25 USD in 1 Tag
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
Hi Regarding this project, I have got lots of experince and confident to give you fast results. Though new to Freelancer, but i have got good amount of experience of working on more than 50 APIs stimulated projects and thus giving me enough confidence to fulfill the requirements of your project. Through my professional journey I have got more than 4 years of experience working with latest APIs (e.g. Ebay, Amazon, DHL, UPS, FedeX, Quickbooks, Myob, Yahoo Finance, social APIs, bestbuy, champslog, Dwolla, e-conomic, all popular Google and social APIs and many more),CRMs(SugarCRM,Zoho,SalesForce,Vtiger etc.) and technologies such as PHP | MySql | WORDPRESS | JOOMLA |CODEIGNITER | CakePHP and more. I feel self-motivated, an adaptable person having good interpersonal, time management, project management and problem-solving skills with high work ethics. Please give me a chance to serve you. Thanks
$35 USD in 1 Tag
5,0 (1 Bewertung)
0,0
0,0
Avatar des Nutzers
A proposal has not yet been provided
$25 USD in 1 Tag
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
5+ years of Experience on MySQL, MS SQL Server2008, 2012. Worked as a SQL Trainer for Analytics firm. I guess due to some issues, I could not see your attachment. Approach : 1. Understanding your requirement 2. Optimizing your current query Feel free to connect me for further discussion
$27 USD in 1 Tag
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
* Expert in Database Designing, Database Modelling & Database Architecture * Extremely competent with Linux, UNIX, MySQL, PostgreSQL, MongoDB & AWS Database Services (RDS and DynamoDB). * Proficiency in managing configuration, maintenance, migrations of large scale engineering systems and application software & hardware devices with a focus on database administration * Expertise in assessing and mapping business requirements and translating these requirements into techno-functional specifications, designing  custom/latest solutions associated to database development and design * Enhanced database performance, performed restores, implemented recovery procedures, managed performance tuning and conducted regular system backups to safeguard the businesses at critical times * Experience in excellently managing the complex security design, configuration, deployment, administration, management and troubleshooting complex security configurations associated with databases. * Comfortable with Cloud Environments such as AWS VPC, AWS EC2, AWS S3 and the database service in AWS i.e. RDS and Dynamo DB. * Written migrations and multiple re-engineering implementations using stored procedures and stored functions in MySQL/PostgreSQL.
$25 USD in 1 Tag
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
A proposal has not yet been provided
$15 USD in 4 Tagen
0,0 (0 Bewertungen)
0,0
0,0

Über den Kunden

Flagge von BRAZIL
Rio de Janeiro, Brazil
5,0
2
Zahlungsmethode verifiziert
Mitglied seit März 11, 2014

Kundenüberprüfung

Danke! Wir haben Ihnen per E-Mail einen Link geschickt, über den Sie Ihr kostenloses Guthaben anfordern können.
Beim Senden Ihrer E-Mail ist ein Fehler aufgetreten. Bitte versuchen Sie es erneut.
Registrierte Benutzer Veröffentlichte Jobs
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Vorschau wird geladen
Erlaubnis zur Geolokalisierung erteilt.
Ihre Anmeldesitzung ist abgelaufen und Sie wurden abgemeldet. Bitte melden Sie sich erneut an.