En cours

simple SQL Access

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

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

Décerné à :

freeagent11

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

30 $ USD en 0 jours
(1 Commentaire)
1.3

15 freelance ont fait une offre moyenne de 30 $ pour ce travail

eperfections

Accept my bid and allow me to write this query.

30 $ USD en 1 jour
(84 Commentaires)
6.1
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

30 $ USD en 0 jours
(15 Commentaires)
4.5
simplicityq88

You have it for free in your PM :)

30 $ USD en 0 jours
(11 Commentaires)
3.1
Humanier

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

30 $ USD en 0 jours
(5 Commentaires)
2.7
botaksakuragi

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

30 $ USD en 0 jours
(0 Commentaires)
0.0
bharatmaru

i can do this, lets start.

30 $ USD en 0 jours
(0 Commentaires)
0.0
Visionary009

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

30 $ USD en 0 jours
(1 Commentaire)
0.0
sergiobc1976

No problem... it takes 10 minutes.

30 $ USD en 0 jours
(0 Commentaires)
0.0
DataAppGuru

Please see PMB for details. Thanks.

30 $ USD en 1 jour
(0 Commentaires)
0.9
Achmad78

Sir, please check my PM. Thanks

30 $ USD en 0 jours
(0 Commentaires)
0.0
iCode

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

30 $ USD en 1 jour
(0 Commentaires)
0.0
ninhtay

I can do it today.

30 $ USD en 1 jour
(0 Commentaires)
0.0
ipt

i will help u

30 $ USD en 0 jours
(0 Commentaires)
0.0
arwadtafesh

Please give me this chance

30 $ USD en 0 jours
(0 Commentaires)
0.0