Cancelled

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

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.

Skills: MySQL, PHP, SQL

See more: simple grid frontend sql query, select query sql cart, sql comparing results select statements, create simple sql query, simple delete query sql php, sql query tree structure result, write sql query display job title employees manager, access database sql simple project, tree query sql, dnn query sql, php html query sql, query creator simple, run query cron simple, uusing data adaptor aspnet query sql server database, parent child query sql server, net query sql mobile table example, parent child query sql, query sql 2005 csv, simple sql query creator, simple sql query, sql query find number child elements, specialise sql query, getafreelancer message sql query help needed, sql query tree children, sql query tree structure

About the Employer:
( 76 reviews ) eské Budjovice, Czech Republic

Project ID: #14695330

Awarded to:

ShoebMonty

I have 4+ year experience in web and php development.I can create fast and secure application with full code functionality

$5 AUD / hour
(8 Reviews)
3.1

35 freelancers are bidding on average $6/hour for this job

toxsltech

Hi I am Shiv and having 15+ years experience in "Website Development".  We are extensively experienced in Magento, HTML, CSS, Bootstrap, MySQL, Javascript, jquery, PHP, Ajax, Json. We have done 750+ projects. Let More

$8 AUD / hour
(111 Reviews)
8.3
mituld

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 / hour
(369 Reviews)
8.1
spiretech

Hello, A satisfied client is like a billion dollar smile to us!!! I have gone through the post and yes; I will help you for sure to complete the project successfully on time and with quality. Our recently developed More

$8 AUD / hour
(64 Reviews)
6.6
shreeyait

Hello Sir, Hope you are fine there. We are having good experience with CorePHP projects and the reason we came across here to give the best output to your project with supreme quality. We have developed a di More

$5 AUD / hour
(64 Reviews)
7.0
XpertCoolDev777

I value trust the most. No need to speak much. Project will show all. I wish we talk more about the project during interview. Please suggest suitable time to discuss seriously. Sincerely.

$5 AUD / hour
(4 Reviews)
5.3
FiveGoldenStar

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. tha More

$5 AUD / hour
(6 Reviews)
4.8
phiona06

select t1.device_id, [url removed, login to view] from table1 t1 inner join (select device_id from table1 group by device_id having count(device_id)>1 ) t2 on t1.device_id=t2.device_id order by t1.device_id, [url removed, login to view] desc

$5 AUD / hour
(26 Reviews)
4.7
ref2

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 / hour
(18 Reviews)
4.1
vw7590795vw

Please review my profile. [url removed, login to view] 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 / hour
(19 Reviews)
3.9
cherrystuart83

Hello Sir/Ma'am, We are the team of IT professionals, with experience of 6+ years in Web technologies/Mobile Application development , software development. We have successfully worked with Joobi, Joomla, Joomsocial a More

$8 AUD / hour
(22 Reviews)
3.9
yony82

I am a very experieced web developer, with a lot of experience working with sql, including advanced queries and performance optimization

$5 AUD / hour
(10 Reviews)
3.3
$5 AUD / hour
(6 Reviews)
3.0
amr77mohamd

Let's get that 5 starts :D ................................................................................

$5 AUD / hour
(12 Reviews)
3.1
$8 AUD / hour
(2 Reviews)
1.4
nidhi0257

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 More

$6 AUD / hour
(2 Reviews)
1.6
hSolanki93

Hi, I'll do the task right away. I'm in need of review. I'm Hitesh Solanki from Panda Softwares. I have build many websites and have 4 years of experience with web and mobile application development. I have made ch More

$2 AUD / hour
(1 Review)
0.8
toshazed

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 wi More

$8 AUD / hour
(2 Reviews)
1.3
skavras

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 / hour
(1 Review)
0.6
bhupen2606

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, More

$5 AUD / hour
(0 Reviews)
0.0
bhandarkars

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 / hour
(0 Reviews)
0.0