Suljettu

2 simple sql Queries on the table in excel file - bid only if you can do it now for 10$

open the excel file you can use any sql db to work on

and do 2 Queries according to the following explanation

And the results according to the examples

The results should be saved in an Excel or CSV file

Send me the query too

1. Each ID number from column L should have only one product of each type, a product type listed in column A.

2. Each order number from column J may have only one product of each type

In column A

Find which ID numbers from column L

There is more than one type of product, and what is the order number listed in column J

And what are the products that have more than one

output samle in excel csv

L = 330810144- : J = 1167 : A = 824,823

Find out which order number from column J has more than one type of product, and what the identification number in column L is, and what are the products that have more than one.

output sample: in excel or in csv

J = 1753 : -L = 217357839 : A = 824,823

Taidot: SQL

Näytä lisää: update excel sheet using sql query, excel query table in same workbook, excel sql tutorial, create sql query in excel, sql query in excel, sql select * from excel sheet, query formula in excel, dynamic ssis package to import excel files into sql server database, excel queries and connections, sql query against excel worksheet, ssis excel source sql command, how to create a query in excel 2016, sql create table csv file, create sql server table csv file, inserting xml file sql server table, net sql server table write excel pivot, access update table excel file, sql table import file indian states list, exporting sql table txt file command line, vbnet update sql server table xml file

Tietoa työnantajasta:
( 2 arvostelua ) jerusalem, Israel

Projektin tunnus: #26922792

14 freelanceria on tarjonnut keskimäärin 21$ tähän työhön

TEKSCENT

I have around 10 years of professional experience in sql development and worked in more than 200 [login to view URL] discuss your requirements.

$25 USD 1 päivässä
(9 arvostelua)
3.9
ahaseeb7838

Hi, I'm expert in SQL and databases. I can start it right now and will complete in few hours. Let's connect. Thanks

$10 USD 1 päivässä
(2 arvostelua)
3.3
mostafawalker

I'm highly skilled C# programmer and Desktop developer, worked with Excel many times before and (SQL, Oracle, MS Access), please contact me to discuss details and chat.

$30 USD 1 päivässä
(5 arvostelua)
2.9
nidhi1509

I have more than 8 years of experience working with top IT companies as a database developer specialized on SQL queries. I have gone through your project requirements. I can start working on this project immediately a Lisää

$15 USD 1 päivässä
(5 arvostelua)
2.9
viveksr

Hi, I have generated the data as per you requirment using the attched excel file and the sample is attached here in a google drive link - [login to view URL] Lisää

$10 USD 1 päivässä
(1 arvostelu)
1.4
kamyshevanskiyv9

Hello! I have got your requirement carefully. I am a creative and professional full-stack developer having more than 4+ years of professional experience as a senior developer in this field. I have experience with: * Lisää

$20 USD 7 päivässä
(0 arvostelua)
0.0
kholmogorovadev

Hi. I can do it soon. this is too easy job. please contact me, and finish this job in 1 hour. regards. Alexandra...

$30 USD 7 päivässä
(0 arvostelua)
0.0
Farhan005

hi there, I have more than 7 years of experience working with Excel files and sql queries. I can write complex formulas, work with queries and user advance features of Excel and sql. I look forward to hearing from you. Lisää

$30 USD 1 päivässä
(0 arvostelua)
0.0
puneetsingh01

Hi - I have understood your request and I have downloaded the excel sheet and have the solution ready. I will like to share the solution with you if you give me the opportunity. Just wanted to add that I am a certified Lisää

$30 USD 7 päivässä
(0 arvostelua)
0.0
kennethpang95

I have experience in loading files into PostgreSQL database and extracting the results into a csv file using advanced queries if needed Relevant Skills and Experience I will be graduating from Imperial College London Lisää

$26 USD 1 päivässä
(0 arvostelua)
0.0
GreekGodofStats

I am an SQL expert Relevant Skills and Experience I am an expert in SQL Server and MS Excel

$25 USD 1 päivässä
(0 arvostelua)
0.0
andrewmehaffy

Hi, Having worked in finance and tech consultancies for the last 5 years I can get this done immediately. Will do for $10 right now.

$10 USD 1 päivässä
(0 arvostelua)
0.0
vascubrian

Hi there! I'm a full stack software engineer, with over 5+ years experience dealing with the different programming languages, and I can help you to work on this project since previously I have been working on the same Lisää

$20 USD 7 päivässä
(0 arvostelua)
0.0
LalithaaMadhu

Your project is ready. you can contact me and get the solution. Ready to explain in detail with examples

$10 USD 1 päivässä
(0 arvostelua)
0.0