Terminé

simple SQL Access

Budget $30-250 USD

Hi

I need help with a Access SQL.

I have to find the top records in a table. This can be done with a query/subquery.

Bid only if you can do this today.

The top must be calculated for each combination:

I need the top 5 "codcliente" for each combination of año / semana / codsubfam.

The value is in field "sumadeKgVE" (this is sum of Kg).

You may import this table to a Access database and send me the sql statement.

Thanks

Compétences : Microsoft Access, SQL

en voir plus : top query, need sql help, sql microsoft access, microsoft access sql, sql microsoft, sql import, SQL Access, simple query, import sql, access sql, access microsoft, need access database help, microsoft query top, access query table, sql statement help, access table query, access sql query, sql query access, simple import, need simple database access, help access, sql query help, sql query access database, sql query field, access simple

Concernant l'employeur :
( 67 commentaires ) Silla, Spain

Nº du projet : #1036719

Vous cherchez à gagner de l'argent ?

projet Terminé
Fixez votre budget et votre échéancier
Décrivez votre offre
Faites-vous payer pour votre travail
L'inscription et postuler à des emplois sont gratuits

Décerné à:

freeagent11's Profile Picture
freeagent11

i can do this. you have 120 combination of [Año, Semana, CodSubFam].

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 0 jours
(1 Évaluation)
1.3

15 freelance font une offre moyenne de $30 pour ce travail

eperfections's Profile Picture
eperfections

Accept my bid and allow me to write this query.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(84 Commentaires)
6.1
frehmanpk's Profile Picture
frehmanpk

Respected Sir, Much easy task. Just communicate and get work done in live screen sharing in no time. Please see PMB for details & I m Ready to start immediately. Surety of quality work done with 100% accuracy with at Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(15 Commentaires)
4.5
simplicityq88's Profile Picture
simplicityq88

You have it for free in your PM :)

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(11 Commentaires)
3.1
Humanier's Profile Picture
Humanier

Hello, I will send you required query withing few minutes after you accept the bid. Please check PMB for details.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(5 Commentaires)
2.7
botaksakuragi's Profile Picture
botaksakuragi

Hi, I am ready to create the SQL for you :)

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(0 Commentaires)
0.0
bharatmaru's Profile Picture
bharatmaru

i can do this, lets start.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(0 Commentaires)
0.0
Visionary009's Profile Picture
Visionary009

Hello sir, I am experienced in SQL. Do the work immediately. Kindly check PM.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(1 Évaluation)
0.0
sergiobc1976's Profile Picture
sergiobc1976

No problem... it takes 10 minutes.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(0 Commentaires)
0.0
DataAppGuru's Profile Picture
DataAppGuru

Please see PMB for details. Thanks.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.9
Achmad78's Profile Picture
Achmad78

Sir, please check my PM. Thanks

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(0 Commentaires)
0.0
iCode's Profile Picture
iCode

We can build you the query in 3o0 minuntes. Thank you.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
ninhtay's Profile Picture
ninhtay

I can do it today.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
ipt's Profile Picture
ipt

i will help u

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(0 Commentaires)
0.0
arwadtafesh's Profile Picture
arwadtafesh

Please give me this chance

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(0 Commentaires)
0.0

Vous cherchez à gagner de l'argent ?

projet Terminé
Fixez votre budget et votre échéancier
Décrivez votre offre
Faites-vous payer pour votre travail
L'inscription et postuler à des emplois sont gratuits