Käynnissä

Need a small optomization of an SQL query

I have multiple items with different values that have the same group id:

-------------------------------

| id | groupId | val

| 1 | 2 | 1

| 2 | 2 | 3

| 3 | 2 | 6

| 4 | 3 | 1

| 5 | 1 | 5

What I want the outcome:

groupId | val

2 | 1

Taidot: MySQL

Näytä lisää: query sql view dnn, query sql mobile database, tree structure query sql, ajax query sql, tree query sql, dnn query sql, php html query sql, parent child query sql, query sql 2005 csv

About the Employer:
( 33 reviews ) Wichita, United States

Projektin tunnus: #13162905

Myönnetty käyttäjälle:

conankid

I'm available to work now. Please chat with me to discuss on details. With my exp in Mysql I believe I can solve you problem now.

20 $ USD 0 päivässä
(16 arvostelua)
5.0

27 freelanceria on tarjonnut keskimäärin 23 $ tähän työhön

15 $ USD 1 päivässä
(42 arvostelua)
5.2
15 $ USD 1 päivässä
(24 arvostelua)
4.7
rainstreamweb

Hello, This is not copy/paste message. I read your requirements. I am interested for this job. I have expertise in Wordpress, Laravel, Magento, AngularJS, Ruby on Rails, Core PHP etc. technologies and can work on Lisää

25 $ USD 1 päivässä
(7 arvostelua)
4.4
20 $ USD 1 päivässä
(23 arvostelua)
4.5
25 $ USD 1 päivässä
(3 arvostelua)
3.9
nojnish

Hi, I can help you with this task as I have 15+ years in SQL and 5 years in MySQL. understand you want only one value for each groupid. if this is correct then which value out of multiple values you want? is it mi Lisää

20 $ USD 1 päivässä
(1 arvostelu)
3.2
teddytechalp

Hello, We are happy to assist you in this case, we are professional IT company from India having clients across the globe. We are industry Experts working on various domains having experience of more than 3 years. W Lisää

13 $ USD 1 päivässä
(1 arvostelu)
3.0
utkarshkatiyar19

I can do

30 $ USD 1 päivässä
(1 arvostelu)
2.6
bistanil98

EXPERTISE IN SQL our web site www.soarlogic.com I checked the Requirement but i want to discuss this with you,when you are online please ping me Experties in php/mysql,sql,html,html-5,css,css 3,java/Javascrip Lisää

30 $ USD 1 päivässä
(17 arvostelua)
6.5
nivasoftvietnam

TRY VIETNAMESE DEVELOPER. “Trial 30% your work before, pay later” is my work principle. We have a production warranty in 12 months if there are errors from what we made Can you see the Web Wordpress services in the li Lisää

35 $ USD 1 päivässä
(2 arvostelua)
2.4
paddu008

Hi Greeting of the Day!!! Yes I am available with complete expertise and past experience to meet your job requirement and can start right now. So can you please send me the complete detail so that I can analyze Lisää

25 $ USD 1 päivässä
(2 arvostelua)
1.6
suffescom1

Hello, Definitely i will assist you with your project,..I am a professional in this field with an extensive experience of more than 6 years in designing and developing complex websites/web applications from scratch. Lisää

30 $ USD 1 päivässä
(2 arvostelua)
1.4
vinaykumar777sl

Hello, I assume that you already have a SQL database. I ensure that i will write a SQL query so that you can pull the data groupId | val -- 2 | 1. I will provide it immediately. All i need is just access to the databas Lisää

25 $ USD 0 päivässä
(2 arvostelua)
1.0
nehulagrawal05

i am ready...i am ready...i am ready...i am ready...i am ready...i am ready...i am ready...i am ready...i am ready...i am ready...i am ready...i am ready...i am ready...i am ready...i am ready...i am ready...i am ready Lisää

25 $ USD 1 päivässä
(1 arvostelu)
0.6
vbizsolutionss

Hi, I consider our firm eligible for your project requirements as we have well past experiences and knowledge to do such projects successfully. Our comapny is perfect for your project position. Check out our p Lisää

20 $ USD 1 päivässä
(1 arvostelu)
0.3
yuansun235

Hello, So you mean you need to get multiple rows (groupip, value)? or minimum values for every groupid? Thanks, Best, Yuan.

25 $ USD 1 päivässä
(1 arvostelu)
0.4
fabianrussell

A proposal has not yet been provided

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

I my self Shivshankar Namdev .net developer having good knowledge of sql and its method

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

A proposal has not yet been provided

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

Hi there, Thanks for posting your project we are interested in your work & have vast experience in blog creation & customization. We will fix out the problems & that all will be done in few hour & you can che Lisää

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