Find Jobs
Hire Freelancers

Write a query in only SQL - 30/04/2018 12:28 EDT

$10-30 USD

Closed
Posted almost 6 years ago

$10-30 USD

Paid on delivery
If user post comments more frequently than 5 minutes, only latest comment within this time window will be displayed. Ex. comments are received on the same day (time is given in descending order) from the same IP 12:33, 12:32, 12:27, 12:25, 12:21 only comments at 12:33 12:27 and 12:21 must be displayed. This filtering must be implemented using SQL, not ruby and in-memory nor javascript. Bid only if you can write SQL query in PostgreSQL within 30mins.
Project ID: 16837382

About the project

10 proposals
Remote project
Active 6 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
10 freelancers are bidding on average $21 USD for this job
User Avatar
A proposal has not yet been provided
$15 USD in 1 day
4.6 (29 reviews)
4.5
4.5
User Avatar
A proposal has not yet been provided
$17 USD in 1 day
4.9 (15 reviews)
3.8
3.8
User Avatar
i can write this query in less than 20 mins. please show me the tables.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
This sounds failry simple. I have time now and can write this for you as soon as I can understand your exact logic for displaying the timed comments and what your data field names and your tables are titled.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$15 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I am experienced with PostgreSQL since version 8.2. Now i'm using PostgreSQL 9.6 and PostgreSQL 10.1. I can write the SQL script for your case. Regards
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Ready to write a query for you. Table and result line example needed. Also i think you need to filter 12:33 here, you should explain the algorithm in a few more words to me. Providing the answer in 30 minutes after I see it. You can contact me by mail(mrabkevich) or skype(bladeelmer)
$19 USD in 0 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of INDIA
Hyderabad, India
4.8
5
Payment method verified
Member since Feb 11, 2010

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.