Closed

Need Help Trouble Shooting One Issue - repost

Hello,

I need some help finding root cause of an issue that I am working. For some reason one query in Production is doubling measure values when i use SUM and GROUP by functions. That is if i have 10 $ as sales when i use sum and group by it is appearing as 20$. I am using approx about 8 tables with some joins. Same query is working perfect in DEV environment.

Length of the query is probably around 55 to 60 lines

Skills: Oracle, SQL

See more: oracle functions sql, need sql help, shooting, need help website hire source repost, trouble shooting, sql query help, help write short story using words kids, sql query sum, need login using facebook vote, need help sales, need website using simple program, oracle sql query, root cause, production group, need articles using best spinner, sql query oracle, need webmaster using volusion, oracle help, production reason, query sum values, need sentences using word synonyms, query oracle, oracle sql help, need help adding google adsense site, need urgent money help

About the Employer:
( 0 reviews ) India

Project ID: #5324980

26 freelancers are bidding on average $3666 for this job

elboukharimu

Aucune proposition n'a encore été fournie.

$3000 USD in 20 days
(16 Reviews)
4.7
nibiranijum

Hi, First of all thanks for posting such a project. I am oracle certified developer and dba with more than 5 years of experience. I am expert in SQL, PL/SQL. I did lots of oracle project in freelancer. http://ww More

$3000 USD in 10 days
(16 Reviews)
4.5
Reza2012

Hi I have more than 10 years experience in oracle database administration and sql programming. Thanks.

$5555 USD in 30 days
(14 Reviews)
4.3
BhargavaB

Hi This is bhargava . expert in writing oracle queries . i am ready to provide quick and efficient solution . i am ready to start your project . i think you are wrongly chosen the budget . first lets discuss about yo More

$3000 USD in 1 day
(7 Reviews)
3.5
eclipsetechno

Show me the query with 50% upfront. I will solve this as I faced same problem in Oracle apps project. Regards Mit

$4210 USD in 3 days
(1 Review)
2.3
brentmccaw

Please send me the query and I can give you a better estimate. Even if the query is 60 lines it should be very easy to see where potentially the issue is. It is going to be in the joins. Once I see the query I ca More

$3000 USD in 3 days
(1 Review)
1.7
brunohenriquebh

Ainda não foi fornecida uma proposta

$4444 USD in 3 days
(0 Reviews)
0.0
prabalpratap

Hi, I am having oracle senior consultant in my team. please provide your contacts details for further communication.

$4000 USD in 15 days
(0 Reviews)
0.0
ABHISHEK21127

I can not say any thing more than this. I have working experience working with a MNC in india. And this is the first project I am bidding for on freelancer. Test my skill, and you will find it better than others More

$3000 USD in 4 days
(0 Reviews)
0.0
ramubonkuri

Hi, I have 2 years experience in oracle and Mysql [url removed, login to view] experience in writing the complex queries and performance tuning. I understood the problem. I will complete this project within the time line. B More

$4444 USD in 30 days
(0 Reviews)
0.0
abhiboscoguy

I am an expert in SQL and I am sure i will be able to solve your problem. Hope to work with you soon

$3888 USD in 30 days
(0 Reviews)
0.0
vamsikrishnag

Hi, I am having 6+ years of experience in Oracle PL/SQL. Has great experience in debugging queries that are problematic. i am new to freelancer. Provide me sample work so that you can know my [url removed, login to view] is ne More

$3000 USD in 1 day
(0 Reviews)
0.0
iftiOracle

I am Oracle 9i, 10g Certified DBA and Developer with professional and University teaching experience. Hope my skills and experience would bring you the solution sought after. Before i start working for solution, More

$3000 USD in 6 days
(0 Reviews)
0.0
manojmareedu

Hi , I am happy to help You. I will work on Data warehouse in TCS and i am good at pulling the data from various kinds of data marts (joining more than 30 tables at a time) and generating summary from the results. More

$3444 USD in 15 days
(0 Reviews)
0.0
gauravstarvision

I am a expert in oracle sqls and have extensive experience and knowledge. Since I am new to freelance , hence I do not have any reviews yet. But if you provide a chance then for sure I will resolve your problem.

$3333 USD in 5 days
(0 Reviews)
0.0
hollidge

Hello, My work is to debug an application that has all General Motors medical records, this application is used globally (I work with US users only) this application has more than 1100 tables, more than 2500 views, More

$3000 USD in 3 days
(0 Reviews)
0.0
pinakiprasaddas

A proposal has not yet been provided

$4444 USD in 30 days
(0 Reviews)
0.0
hi4ppl

Im oracle Certified Professional not only in Oracle but other Database I can help you out on this I have done this before so no worries...you will get high class support

$3000 USD in 10 days
(0 Reviews)
0.0
kprattip

Hi, I have been working with Oracle from the last 10 Years and I am very good at Oracle Database and Applications. I am oracle certified Professional. I need only 20% deposit initially as this is my first bid, an More

$3888 USD in 5 days
(0 Reviews)
0.0
MVLReddy

Hi, First of all are you sure that you want to pay such high amount for this work? Check my profile to get a better idea about my skills. And one more thing, I need test data and you need to have Production se More

$4000 USD in 2 days
(0 Reviews)
0.0