Mysql Views to be created

In Corso Pubblicato 5 anni fa Pagato alla consegna
In Corso Pagato alla consegna

I have 138 Columns with 365 days are rows. Each day any of 138 columns may have some numeric value, I want to create a view so that I can filter or search sales done on specific item (column value) for the year etc. You need to connect to my desktop for accessing the database.

New View should have 3 columns like Date Value Sale Amount

Value Column will have the values of all original column names found in the table.

Example say if original column is like this:

Date program1 program 2

2/2/2018 1000

3/3/2018 1000

4/4/2018 200 200

I want new View to be like this

Date Value Sale_amount

So that I should be able to generate report like show me all sales generated from Program1 etc

Programmazione Database MySQL SQL

Rif. progetto: #16694825

Info sul progetto

7 proposte Progetto a distanza Attivo 5 anni fa

Assegnato a:

Adan94

Hi, Hope you are doing great. I am data warehousing certified professional and i have work experience of world's Top Data warehouse company "Teradata" .I can easily accomplish this [login to view URL] feel free to contact Altro

₹850 INR in 1 giorno
(0 valutazioni)
0.0

7 freelance hanno fatto un'offerta media di ₹1093 per questo lavoro

ksab

I can help to create the view you want. On your desktop. Thanks

₹850 INR in 2 giorni
(5 valutazioni)
2.3
DSTechPro

A proposal has not yet been provided

₹850 INR in 3 giorni
(1 Recensione)
1.0
jdace1231

A proposal has not yet been provided

₹1300 INR in 1 giorno
(1 Recensione)
0.2
thiagog94

A proposal has not yet been provided

₹1750 INR in 3 giorni
(0 valutazioni)
0.0
gymboyamit

A proposal has not yet been provided

₹750 INR in 1 giorno
(0 valutazioni)
0.0
Apurba83

A proposal has not yet been provided

₹1300 INR in 1 giorno
(0 valutazioni)
0.0