GetACoder.com

 
 

Home | My Account | Post Job | Browse Jobs | RSS Feeds | Careers New!

 

Optimize SQL Request

 
 
     
Job Summary:
 
Job Type: Project
Budget: $ 20-100
Required Skills: MySQL, Oracle PL/SQL, SQL Server
Attached Files: assets (2).rar
 
Status: Work Performed (selected user idocenko)
 
Buyer Summary:
 
Username:
bviguier  
Feedback Score: 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10 7 reviews
Award Reliability: 15 posted 8 paid
 
Location: London, United Kingdom
Member Since: June 25, 2010
 
Invited Users: There are no invited users


Description
I am looking for someone who has a strong experience in SQL to optimize a request.
The request is:
select distinct date,market,maturity,close,0,0,0 from assets where market ='WTI' and date<3625233717 and date>0 and date in(select date from(select date, min(date % (5 * 60)) from assets where (date % (5 * 60)) < 60 and market='SIL' group by (date - date % (5 * 60)))dte)order by date;
DO NOT Apply if you do not understand this request, and if you are not sure to improve it.
I m expecting the optimized version to reproduce the same results as the original version.




Reminder
You may not start working in this and any request before your bid is accepted. Users who violate this policy may have their accounts permanently suspended.



 Bids Received (9)   Shortlist (0)   Declined Bids (0)   
Average bid amount:   $123.33   Average delivery time:   3 Day(s)
Place Bid | Post Similar Job | Send Request | Contact bviguier

Order by:

 

Remember that contacting the other party outside the site (by email, phone, etc.) on all business jobs (before the request is awarded) is a violation of our terms of use. We supervise all site activity for such infringements and can immediately expel transgressors on the spot, so we thank you in advance for your cooperation. If you notice a violation please help out the site and report it. Thank you for your help.
 

 
send private message
 
Premium User  
idocenko  
Kiyv, UA
location
US$50
bid amount

9.76/109.76/109.76/109.76/109.76/109.76/109.76/109.76/109.76/109.76/10
(184 reviews)

feedback
1 day(s)
delivery time

 
 
i've seen query. i can speed up it. please, feel free and write in chat for discussion. thanks!
Bid Time: 12-08-2011 15:12
 
send private message
Shortlist
Decline Bid
Premium User  
quickbeyond  
Ahmedabad, IN
location
US$500
bid amount

9.39/109.39/109.39/109.39/109.39/109.39/109.39/109.39/109.39/109.39/10
(33 reviews)

feedback
7 day(s)
delivery time

 
 
Dear Sir , We read your project requirement and decided to work with you on this project. We are seriously interested in your project. Project will deliver in timely manner. We are ready to start this project now .We wants to make long term business relationship with you. We assure you a great output of this project . Please invite us chat because as per GAC new rule we can’t send your our portfolio until you will not reply us . Kind regards Quick beyond Team .
Bid Time: 12-08-2011 00:06
 
send private message
Shortlist
Decline Bid
Premium User  
smartsolutiontec  
Guelph, CA
location
US$20
bid amount

10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(14 reviews)

feedback
1 day(s)
delivery time

 
 
Your query is ready.
Bid Time: 12-08-2011 02:12
 
send private message
Shortlist
Decline Bid
Premium User  
CleanCodeExpert  
brno, CZ
location
US$20
bid amount

7.55/107.55/107.55/107.55/107.55/107.55/107.55/107.55/107.55/107.55/10
(11 reviews)

feedback
1 day(s)
delivery time

 
 
Greetings, We are a team of mssql and e-commerce experts. We will handle your work with the highest quality and follow up. Please open the chat so we can get on details and get started.
Bid Time: 12-08-2011 10:21
 
send private message
Shortlist
Decline Bid
zkr  
Dhaka, BD
location
US$100
bid amount

10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(10 reviews)

feedback
1 day(s)
delivery time

 
 
Hello, You can try with me... Please open PMB, give me access of your original DB ..
Bid Time: 12-07-2011 23:12
 
send private message
Shortlist
Decline Bid
n9231658900  
Kolkata, IN
location
US$100
bid amount

(No Feedback Yet)
feedback
1 day(s)
delivery time

 
 
We have more than 7 years of experience in Software Fields to work with commercial customers around USA as well as all around Glob. Customer satisfaction is our valuable profit. We have expertise in various domains and having enough work experience in it. We have expertise and experience in SQL-SERVER, ORACLE, MS-ACCESS, MYSQL We need to discuss further so that we could start the project as soon as possible. Hope to meet soon. Thank you.
Bid Time: 12-07-2011 22:58
 
send private message
Shortlist
Decline Bid
softcoder05  
Ahmedabad, IN
location
US$100
bid amount

(No Feedback Yet)
feedback
5 day(s)
delivery time

 
 
Dear Buyer, We are the team of 15-20 People including developers and designers. Our team includes experienced persons in field of different technologies. Our Customer set belongs to Europe, USA , Australia and many other countries around the Glob. We are providing our services to many different and advanced technologies. Our work field includes CMS (Content Management System), Web Technologies, Application Software Development and Real-time Software development. We have more than 7 years of experience to work with Joomla, Drupal, Wordpress, Magento, VB.net, C#.net, ASP.net,JAVA, J2ME, JSP, VB, PHP, MySQL, MSSQL, C, C++. Visit our portfolios to know about my work and We are not a premium member of GetaCoder so can't add more then 5 portfolios. Please connect via chat for further discussion. Thanks Regards Softcoder05
Bid Time: 12-08-2011 01:40
 
send private message
Shortlist
Decline Bid
shad32  
Beirut, LB
location
US$120
bid amount

(No Feedback Yet)
feedback
1 day(s)
delivery time

 
 
if you chose me , i'm an expert in oracle sql
Bid Time: 12-08-2011 12:18
 
send private message
Shortlist
Decline Bid
incessant  
hyderabad, IN
location
US$100
bid amount

(No Feedback Yet)
feedback
7 day(s)
delivery time

 
 
we are interested in the project...whats the best time to talk ?
Bid Time: 12-08-2011 12:33
 
 


 
Get the Free Step-by-Step Guide on How to Use GetACoder
The act of outsourcing jobs has become easy in the past few years thanks to GetACoder. However, our team aims at making the whole process even easier. So, it has now come the time to provide you with a step-by-step guidance on how to use this service and succeed in the outsourcing world totally for FREE.

It doesn't matter if you are a more experienced user or a novice; using GetACoder will become even simpler with the help of this E-book. There are two major sections: a Buyers section and a Coders section.

Buyers will learn:
  • How to outsource safely
  • How to pick the best freelancers
  • How to manage time and money

Coders will learn:

  • How to get the best jobs
  • How to secure their payments
  • How to build a long-lasting relationship with buyers

    ...and MUCH MORE
Clear examples and pictures illustrating key situations, great tips and real testimonies of some of our best users... all in this Outsourcing Guide.  So don't loose the outstanding opportunity to download GetACoder FREE E-book.
The Outsourcing Revolution: Why It Makes Sense and How to Do It Right
The Outsourcing Revolution: Why It Makes Sense and How to Do It Right
What is GetACoder?

GetACoder.comGetACoder is a leading Global Services Marketplace doing business in more than 200 countries. Our unique system accelerates your time to market and provides your business with key competitive advantages. When you use GetACoder you are stretching your budget and saving as much as 60% over traditional outsourcing. GetACoder is changing business, now it's no longer about what you own or build but which resources and talent you can access. With GetACoder you reduce expenses, increase efficiencies, aggressively grow your business, and create a sustainable competitive advantage. GetACoder makes outsourcing to any part of the world an easy task! With GetACoder it's simple to outsource any business request, gain access to global talent and manage jobs online.

One of the main advantages of GetACoder is the low labor cost. The typically rates are about seven times lower than the ones in the US or Europe. Posting a request at GetACoder allows the right professional or company to find you and to bid for your work. We are building a reputation for exceeding our customers' expectations and for becoming an extremely cost effective way to outsource work. Use GetACoder when you want to save money, increase efficiency or accelerate the development of your request. With GetACoder you focus on growing your business and let others do the tedious work. Post your request on GetACoder for free. Find out why people outsource jobs with us day after day.

Thousands of Satisfied Customers - Submit/View Quotes


-thanks a lot for the nice and easy to work freelance site. I will make many project here. - deprowebs
-This is an awesome contribution to the freelance community... I really love this site. - waseem
-Superb!! GAC provide us with great opportunities at low cost. - cipvtl
Report Violation    Privacy Policy     Affiliate Program    Terms of Use    Contact Us    Help      GetACoder.com on Facebook      Follow GetACoder on Twitter      GetACoder.com Latest Requests RSS Feed
© 2004-2012 GetACoder. All rights reserved.