Find Jobs
Hire Freelancers

Simple SQL Query (5 dollar job, must be done right now, 5 STAR review)

$2-8 AUD / hour

Completato
Pubblicato quasi 7 anni fa

$2-8 AUD / hour

You see a screenshot of sorted data by device_id and ts_start (timestamp when session started). I need to run a search that will SELECT only rows where device_id is same but the first row has licence type 0 and second row licence type 1 when comparing. This would result in device_id that upgraded from 0 to 1. Then just alter the code, so I can look for downgrades, meaning where in the first row licence is 1 and then 0.
Rif. progetto: 14695330

Info sul progetto

31 proposte
Progetto a distanza
Attivo 7 anni fa

Hai voglia di guadagnare un po'?

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze
Fatti pagare per il lavoro svolto
Delinea la tua proposta
La registrazione e le offerte sui lavori sono gratuite
Assegnato a:
Avatar dell'utente
I have 4+ year experience in web and php development.I can create fast and secure application with full code functionality
$5 AUD in 1 giorno
5,0 (12 valutazioni)
3,9
3,9
31 freelance hanno fatto un'offerta media di $6 AUD/ora
Avatar dell'utente
Hi I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers. I ensure 100% customer satisfaction so lets start Thanks
$7 AUD in 40 giorni
4,8 (474 valutazioni)
8,3
8,3
Avatar dell'utente
I am a very experieced web developer, with a lot of experience working with sql, including advanced queries and performance optimization
$5 AUD in 1 giorno
5,0 (35 valutazioni)
6,2
6,2
Avatar dell'utente
Hi I am senior software developer. My major skills are C# C++ PHP .NET. MYSQL, I have already studied about your job description carefully and decided to involve into your dream . please contact me if you mind. thanks.
$5 AUD in 40 giorni
5,0 (7 valutazioni)
4,9
4,9
Avatar dell'utente
If i have understood your requirement correctly, you are looking for 2 queries to be written to identify upgrades and downgrades of the devices. If this is correct, let me handle it. Though i have quoted per hour rate, you can pay as per your capacity.
$5 AUD in 40 giorni
5,0 (57 valutazioni)
5,0
5,0
Avatar dell'utente
Please review my profile. https://www.freelancer.com/u/vw7590795vw.html I have 7 years and 8 months experience in SQL. Please let me know more details and when we will start. Sky pe jikenjd
$5 AUD in 0 giorno
5,0 (25 valutazioni)
4,2
4,2
Avatar dell'utente
I have 20 years of experience in dev app on oracle CS degree 25 oracle certified trainings I will create these data on my database and send you the query for desired output
$8 AUD in 40 giorni
4,8 (22 valutazioni)
4,5
4,5
Avatar dell'utente
Let's get that 5 starts :D ................................................................................
$5 AUD in 40 giorni
4,9 (12 valutazioni)
3,6
3,6
Avatar dell'utente
I am Ring. I am about 16+ years experienced in GNU/Linux based system, server installation and customization, develop, deploy, security and support. I may help you in this regard if you can provide me the same table with demo data.
$8 AUD in 3 giorni
4,7 (6 valutazioni)
3,1
3,1
Avatar dell'utente
4.2 years of IT experience in software development on Core java, J2EE, Spring, struts 2, web services, Cobertura, restful interface, JSON, MQTT client, spring MVC, mosquitto, Amazon s3. Currently working on Spring MVC, Hibernate, core java, REST services, JSON's, swagger, mockito, Junit, Mongo DB,postgreSql, SQL, webSocket, Oauth2, SpringBoot, Gradle. Over 2.3 year of experience in Banking and Finance Domain. Good in OOA/ OOD skills, SAX parsing. Experience in development of Web & SQL Applications and other n-tiered distributed applications using techniques like Waterfall model, Agile methodology etc. Receptive, self-motivated professional providing creative solutions, working constructively as a team member or independently. Team player with good interpersonal & communication skills and ability to multi-task. Strong hands on experience on SDLC model. Excellent organizational, planning, project and time management skills.
$6 AUD in 10 giorni
5,0 (2 valutazioni)
1,6
1,6
Avatar dell'utente
Yes, you're right: it is 5 dollars job :) I'm free today and can do this for you in minutes. Could you please tell me at least the table name for the query and list of columns or this table? Sincerely, Sergii
$5 AUD in 20 giorni
5,0 (1 valutazione)
0,4
0,4
Avatar dell'utente
SQL expert with years of experience. I will do it in 10 mins. Looking for your reply. Thank you.
$5 AUD in 40 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
I have more than 16 years in writing SQL queries. I will be able to help in writing this one quickly and work with you on other queries if needed. This is my first project in this system so I appreciate if you give me the opportunity to get started. If you are not satisfies with the result then no need to pay me.
$5 AUD in 40 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
Hi, I am recently graduated and looking for small/big working experience projects to put in my portfolio. I am keen to do this at no cost for you. Let me know if I can help. All the best,
$5 AUD in 40 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
I will assure you applause for my work, if we are working on it!
$5 AUD in 1 giorno
0,0 (0 valutazioni)
1,2
1,2
Avatar dell'utente
A proposal has not yet been provided
$4 AUD in 1 giorno
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
• Having 2.6 years of professional experience in Software in the Analysis, design, development of software applications. • Experience in Oracle 10g, 11g, SQL, PL/SQL and unix. • Having knowledge on writing SQL queries. • Proficient in PL/SQL and creation/modification of database objects like Tables, Packages, Procedures, Functions, Triggers, views, Sequences, Synonyms. • Experience in PL/SQL Collections, Ref Cursor, and Bulk collect, Pragma Autonomous Transaction. • Created materialized views to enhance the performance. • Well experienced in creating user defined types like Index by table, PL/SQL record, Nested Tables, Varrays. • Good knowledge on loading data from flat file into oracle base tables using SQL*LOADER. • Experienced with UNIX including basic commands. • Having knowledge on DBA concepts like creating users, grant and revoking permissions. • Project Experience in Telecom, manufacturing domain. • Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application. • Having experience in Forms 10g and Reports 10g.
$5 AUD in 40 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
I am a MNC working software engineer and having good of sql query writing experience. I try to provide the SQL query ASAP
$5 AUD in 40 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
let me know how the ts_start value is calculated and what is the order (sort) of ts_start attribute. Then its simple to write query to find downgraded and upgraded devices.
$5 AUD in 40 giorni
0,0 (0 valutazioni)
0,0
0,0

Info sul cliente

Bandiera: CZECH REPUBLIC
eské Budjovice, Czech Republic
5,0
78
Metodo di pagamento verificato
Membro dal nov 18, 2013

Verifica del cliente

Grazie! Ti abbiamo inviato tramite email il link per richiedere il tuo bonus gratuito.
Non è stato possibile inviarti l'email. Riprova per piacere.
di utenti registrati di lavori pubblicati
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Caricamento anteprima
Autorizzazione per la geolocalizzazione concessa.
La tua sessione è scaduta ed è stato effettuato il log out. Accedi nuovamente per piacere.