Lengkap

MS SQL Query

SQL query needed. I have a three columns of data. First column is Business Segment, [A, B, C] second column is Nationality(English, Australian, American, German, French, Indian, Spanish, Itlalina, Turkish and so on.....), third column is count with value of 1 for each row.

Total records are 2000. (please create mock up of data yourself)

need to SQL to out put data in three columns. So First Column should give the segment (A, B, or C), second column should be Max % of Nationality (by counting total number of Nationalities and get the % of the nationality which is occurring highest), and third Colum to tell me what that nationality actually is (for example Indian or American or German etc), for each Business segment. that's all.

Kemahiran: Pentadbiran Pangkalan Data, Pembangunan Pangkalan Data, Pengaturcaraan Pangkalan Data, MySQL, SQL

Lihat lagi: microsoft t sql, sql server management studio, sql syntax, sql software, sql server query examples, sql server, sql column, sql queries pdf, vbnet sql print query, excel sql multiple query, query find distinct row latest entry, sql server query tree parent, creloaded sql search query, sql server query rijndael aes net, sql customers query, sharepoint sql report query caml, sql search query filter, wordpress sql custom query category, sql write query, convert ms sql query mysql

Tentang Majikan:
( 24 ulasan ) Dublin, Ireland

ID Projek: #19054322

Dianugerahkan kepada:

freelanceprgmr

Dear sir I am an experinced web developer especially in PHP SQL. I have lots of experiences in mysql queries I can do the task for you ASAP and very optimized.

$10 USD dalam sehari
(3 Ulasan)
1.2

12 pekerja bebas membida secara purata $24 untuk pekerjaan ini

liangjongai

Hi, sir I have read carefully about your requirements. I have best skills and much experiences in MSSQL Query I have already completed so much projects and get good reviews from employers. I am sure I can complete Lagi

$30 USD dalam sehari
(171 Ulasan)
7.2
kipdev13

Hi, sir I read your requirement carefully. I can support you well. I have great skills in database . I am sure I can complete your project! If we have chat, then we can be sure for each other. Let's start this wo Lagi

$25 USD dalam sehari
(46 Ulasan)
6.3
xinglong717

Hello I'm the full stack developer. I understood all about your job. so there is no problem for me to complete your project with my skill. I can do work your job perfectly. Hope to work with you as soon as poss Lagi

$25 USD dalam sehari
(24 Ulasan)
4.8
logicalsoft

Need to talk with customer to discuss Need to talk with customer to discuss Need to talk with customer to discuss Need to talk with customer to discuss Need to talk with customer to discuss

$20 USD dalam sehari
(17 Ulasan)
4.9
codered333

This should be a fairly quick project. I have all 5/5 reviews so with me you know the job will get done quickly and accurately. If you have any questions feel free to ask!

$35 USD dalam sehari
(18 Ulasan)
4.6
huseyinaygun

Hi, I have SQL and relational database design and development experience of 10 years. Lately I completed 4 Database Systems course projects which cover: - Conceptual design, Logical design, Normalization - Cre Lagi

$24 USD dalam sehari
(5 Ulasan)
3.2
itouhideo

Hi, I am a sql expert, and I am very interested in your requirement. I have some questions for you. Let's discuss the detail. Please contact me at anytime. Sincerely, Thank you in advance.

$25 USD dalam sehari
(3 Ulasan)
2.0
josemontenegro13

Computer Engineer. Plenty of experience solving algorithmic problems in a wide variety of environments and tools, including making sql queries and working with databases in general

$30 USD dalam sehari
(2 Ulasan)
1.7
jboo7

Hello, I worked a lot with PostgreSQL and simple SQL, i think i am able to resolve your task. Lets discuss the details.

$20 USD dalam sehari
(1 Ulasan)
1.6
Hadihilal

hello sir, i am hadi web developer am ready to offer to you all my Experience to your project i will happy to work with you ... i am waiting for your message ...

$25 USD dalam sehari
(0 Ulasan)
0.0
mikhailalexey

Hi, I am able to handle your require perfectly. As you can see from my freelancer profile, I have good skills and experiences to satisfy your requirements. I would like to discuss more details by chatting and Lagi

$15 USD dalam sehari
(0 Ulasan)
0.0