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.

Evner: MySQL, PHP, SQL

Se mere: 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

Om arbejdsgiveren:
( 77 bedømmelser ) eské Budjovice, Czech Republic

Projekt ID: #14695330

Tildelt til:


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

$5 AUD / time
(8 bedømmelser)

33 freelancere byder i gennemsnit $6/time for dette job


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 / time
(443 bedømmelser)

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 Flere

$8 AUD / time
(120 bedømmelser)

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 Flere

$8 AUD / time
(83 bedømmelser)

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 Flere

$5 AUD / time
(68 bedømmelser)

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 / time
(6 bedømmelser)

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 Flere

$5 AUD / time
(7 bedømmelser)

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 Flere

$8 AUD / time
(40 bedømmelser)

select t1.device_id, [login to view URL] 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, [login to view URL] desc

$5 AUD / time
(29 bedømmelser)

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 / time
(21 bedømmelser)

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 / time
(23 bedømmelser)

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

$5 AUD / time
(24 bedømmelser)

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

$5 AUD / time
(15 bedømmelser)

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

$5 AUD / time
(12 bedømmelser)
$5 AUD / time
(6 bedømmelser)

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 Flere

$2 AUD / time
(4 bedømmelser)

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 Flere

$8 AUD / time
(3 bedømmelser)
$8 AUD / time
(2 bedømmelser)

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 Flere

$6 AUD / time
(2 bedømmelser)

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 / time
(1 bedømmelse)

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 / time
(0 bedømmelser)