Find Jobs
Hire Freelancers

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

$2-8 AUD / hour

Completed
Posted almost 7 years ago

$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.
Project ID: 14695330

About the project

32 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 day
5.0 (12 reviews)
3.7
3.7
32 freelancers are bidding on average $6 AUD/hour for this job
User Avatar
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 days
4.8 (471 reviews)
8.2
8.2
User Avatar
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 day
5.0 (35 reviews)
6.0
6.0
User Avatar
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 days
5.0 (7 reviews)
4.9
4.9
User Avatar
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 days
5.0 (29 reviews)
4.4
4.4
User Avatar
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 day
5.0 (25 reviews)
4.2
4.2
User Avatar
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 days
4.8 (22 reviews)
4.2
4.2
User Avatar
Let's get that 5 starts :D ................................................................................
$5 AUD in 40 days
4.9 (12 reviews)
3.1
3.1
User Avatar
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 days
4.7 (5 reviews)
3.1
3.1
User Avatar
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 days
5.0 (2 reviews)
1.6
1.6
User Avatar
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 days
5.0 (1 review)
0.5
0.5
User Avatar
SQL expert with years of experience. I will do it in 10 mins. Looking for your reply. Thank you.
$5 AUD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I will assure you applause for my work, if we are working on it!
$5 AUD in 1 day
0.0 (0 reviews)
1.2
1.2
User Avatar
A proposal has not yet been provided
$4 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
• 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 days
0.0 (0 reviews)
0.0
0.0
User Avatar
try try try try try try try try try try try try try try try try try try try try try try try try try try try try
$3 AUD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CZECH REPUBLIC
eské Budjovice, Czech Republic
5.0
78
Payment method verified
Member since Nov 18, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.