Find Jobs
Hire Freelancers

Correct or provide a correct SQL statement for grouping data from single table.

£10-20 GBP

Terminado
Publicado hace más de 5 años

£10-20 GBP

Pagado a la entrega
I have a table that has 5 fields. MyTable (ts int, pid int, pfc int, psc int, spt int) The table stores unique records. I mean no record will present in the table twice. The stored data essentially is grouped by the "ts" field. I mean all the records that have the same "ts" value can be considered a single group. The task is to write a SQL statement in such a way that we find the frequency of the records with respect to a single group and with respect to the entire groups. For example: If we have this records: INSERT INTO MyTable VALUES (10, 1, 0, 0, 0) ; INSERT INTO MyTable VALUES (10, 1, 0, 0, 0) ; INSERT INTO MyTable VALUES (10, 1, 0, 0, 1) ; INSERT INTO MyTable VALUES (10, 1, 0, 0, 1) ; INSERT INTO MyTable VALUES (10, 1, 1, 0, 1) ; INSERT INTO MyTable VALUES (11, 1, 0, 0, 1) ; INSERT INTO MyTable VALUES (11, 1, 0, 0, 1) ; INSERT INTO MyTable VALUES (11, 1, 0, 0, 1) ; INSERT INTO MyTable VALUES (11, 1, 0, 2, 0) ; INSERT INTO MyTable VALUES (11, 1, 0, 2, 0) ; The final result of the desired SQL statement is ts | pid | pfc | psc | spt | thiscount | accmulatedcount 10 | 1 | 0 | 0 | 0 | 2 | 2 10 | 1 | 0 | 0 | 1 | 2 | 2 11 | 1 | 0 | 0 | 1 | 3 | 5 <-- because we have 2 in the 10 group 11 | 1 | 0 | 2 | 0 | 2 | 2 11 | 1 | 1 | 0 | 1 | 0 | 1 <-- NOTICE: thiscount =0 because no reletive record in the group 11 HOEVER the "accmulatedcount" reveals the "1" from the previous records in any. If we have more than groups then we should do the same with them. For a clear example please see the attached image.
ID del proyecto: 17525236

Información sobre el proyecto

17 propuestas
Proyecto remoto
Activo hace 6 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
£21 GBP en 1 día
4,9 (13 comentarios)
4,3
4,3
17 freelancers están ofertando un promedio de £17 GBP por este trabajo
Avatar del usuario
Hello There, I have been working with postgresql, sql, sqlite since last 4+ years. I can do your project. I would like to do your project. Message me for more details.
£13 GBP en 1 día
4,6 (9 comentarios)
3,6
3,6
Avatar del usuario
I have more than 3 years of experience working with databases such as oracle and MSSQL with complex queries
£18 GBP en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
hello sir, I have great knowledge in core development and more than 4 year experience. also I can do your task in few hours. thanks
£13 GBP en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I have done task like this before. I can do it confidently. To write the query so that you will get count of repeated int in column and complete table, I have syntax ready.
£18 GBP en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hey I have read & understood your requirements. I have already done similar kind of jobs. I have plenty of time available with me. So i hope you will open a PM for discussion. Thanks Parmod
£18 GBP en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
hi I am experienced developer and i need good feed back because i am new to freelancers. i m bidding very low for feedback only.
£13 GBP en 1 día
4,4 (1 comentario)
0,0
0,0
Avatar del usuario
Hello there i have been working on tsql from a long I believe i can do your task real quick.
£21 GBP en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi there, I have right experience to do this job. Do inbox me for further discussion. I am working on sql server from 4 years. Thanks
£18 GBP en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED KINGDOM
SWANSEA, United Kingdom
5,0
3
Forma de pago verificada
Miembro desde jul 29, 2018

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.