Find Jobs
Hire Freelancers

1 SELECT SQL with subqueries in MS ACCESS

€8-30 EUR

Selesai
Dibuat sekitar 4 tahun yang lalu

€8-30 EUR

Dibayar ketika dikirim
I need 'convert' (do a query select) db_size_test table to have the same as is in RESULT table. If there are 2 values in same day (DateTime) than pick MAX of Size per ClientID. This test is with only 1 ClientID - there can be more Client IDs and and more dates. Resul should be all days of current month with client IDs and Sizes. If there is was no Size in date take size from previous not null value. I need this in 1 SELECT QUERY with subqueries.
ID Proyek: 23940309

Tentang proyek

21 proposal
Proyek remot
Aktif 4 tahun yang lalu

Ingin menghasilkan uang?

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda
Dapatkan bayaran atas pekerjaan Anda
Uraikan proposal Anda
Gratis mendaftar dan menawar pekerjaan
Diberikan kepada:
Avatar Pengguna
straight forward query, i can provide you with a clear documentation on how its done so you do it alone next time without the need to pay for the answer.
€8 EUR dalam 1 hari
5,0 (1 ulasan)
0,0
0,0
21 freelancer menawar dengan rata-rata €20 EUR untuk pekerjaan ini
Avatar Pengguna
Hi I've viewed your Access DB. Very easy job. Simply now here very late and I can code it by tomorrow if awarded. Though if this very urgent I can do this tonight. Thanks, Zurab Ms Access/vb developer
€30 EUR dalam 2 hari
4,6 (50 ulasan)
6,1
6,1
Avatar Pengguna
HI THERE, I WILL WRITE THE QUERY TO DISPLAY THE DATES AND THE TOP VALUE FOR DATE AND WILL MAKE SURE RESULT IS SAME AS THAT OF RESULT TABLE, WILL DO IN FEW MINS RIGHT NOW FOR 8 EUR, THANKS
€8 EUR dalam 1 hari
4,9 (65 ulasan)
5,2
5,2
Avatar Pengguna
SOLVE in HOURS!!! i am ready right now .... MS Access EXPERT with any type of complex Query . 20 years experiences ... ..can you connect me to start ...thanks
€24 EUR dalam 1 hari
4,9 (11 ulasan)
4,8
4,8
Avatar Pengguna
Expert in SQL, placed in the top 3% of all freelancers globally. Lots of 5 star reviews related to SQL, MSSQL, t-SQL, etc. Ready to work right now. Please contact me if you are interested.
€20 EUR dalam 1 hari
5,0 (6 ulasan)
3,3
3,3
Avatar Pengguna
Hello, Nice to meet you. I can do it perfectly. please come to chat so we can discuss in details. Thanks.
€30 EUR dalam 1 hari
5,0 (1 ulasan)
2,8
2,8
Avatar Pengguna
Hi, I'm expert web-developer with 7 years of experience. I have rich experience with MS Access. Please contact me, I'll start right away. Best regards, Yaroslav
€19 EUR dalam 7 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
Hey there I can help you with your project. I have experience working with databases and other tools like vba, python and many others. Let me know if you want me to help you. Greetings
€34 EUR dalam 5 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
hi sir, I will write the query for you for 10 EUR. I have 12 years of experience in the application development. thanks.
€14 EUR dalam 2 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
I can write your queries quickly and efficiently. With the vast experience on MS Access and specific to SQL Queries makes me different from general experts. I have worked with various top customer for their data queries, data migration, data analysis, data reporting and similar activities. Performance Tuning is my area of interest for query optimization.
€15 EUR dalam 1 hari
0,0 (0 ulasan)
0,8
0,8
Avatar Pengguna
I have worked in Ms access for stand alone softwares Relevant Skills and Experience C# .net Ms access
€23 EUR dalam 1 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
I know about queries in SQL language, and how to do what you need. ---------------------------------
€15 EUR dalam 1 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
Hi, I have been studying and creating Databases for many years. I would be happy to assist. Looking forward to your response. Asimina
€18 EUR dalam 1 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
Hello, I have good Experience (8 Years) in the SQL Database query making. I can make the SQL query as per your requirements. Regards, Gurusami S.
€10 EUR dalam 3 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
hello, i have good experience to write sql query and total 6 year of experience on sql. if you are interested please contact me. thanks.
€30 EUR dalam 7 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
I will complete this task in 7 days with the help of Sub Queries and main Query. i has around 8 Years of Good Experience in SSMS. And came across these type of Complex Scenerios a lot of times..
€10 EUR dalam 7 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
I have experience of 5 years in managing data. can easily work on access.....................................................................
€24 EUR dalam 2 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
I have worked on SQL server from last 2 years so able to do your in a best way so want to work on it, able to learn new things
€29 EUR dalam 3 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
Hello, I am having 15+ years of experience in development using databases. I have checked the MS Access database. I am confident that I can work on your requirements and deliver you the query, which will insert the correct result in the results table. Thanks
€8 EUR dalam 1 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
Hi, I'd like to help you with this project. Relevant Skills and Experience SQL, MS Access, MySql
€12 EUR dalam 1 hari
0,0 (0 ulasan)
0,0
0,0

Tentang klien

Bendera SLOVAKIA
Kosice, Slovakia
5,0
8
Memverifikasi Metode pembayaran
Anggota sejak Jan 14, 2013

Verifikasi Klien

Terima kasih! Kami telah mengirim Anda email untuk mengklaim kredit gratis Anda.
Anda sesuatu yang salah saat mengirimkan Anda email. Silakan coba lagi.
Pengguna Terdaftar Total Pekerjaan Terpasang
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuat pratinjau
Izin diberikan untuk Geolokasi.
Sesi login Anda telah kedaluwarsa dan Anda sudah keluar. Silakan login kembali.