Em Andamento

SQL Statement Structure

A single SQL statement that pulls the following data from the table using the rules listed.

Here are the details:

Select

Distinct ID,

Order where order is the smallest

Surname, First_Name,

Qual where Qual is the largest,

Detail where Qual is the largest,

Email where not Null or blank - (Return no record if all emails are Null or blank)

TABLE

ID Order Surname First_Name Qual Detail Email

335 10 user1-lastname user1-firstname [url removed, login to view] A NULL

335 4 user1-lastname user1-firstname [url removed, login to view] B NULL

335 8 user1-lastname user1-firstname [url removed, login to view] C NULL

386 3 user2-lastname user2-firstname [url removed, login to view] D NULL

386 4 user2-lastname user2-firstname [url removed, login to view] E NULL

386 2 user2-lastname user2-firstname [url removed, login to view] F user2@...

778 4 user3-lastname user3-firstname [url removed, login to view] G NULL

778 2 user3-lastname user3-firstname [url removed, login to view] H user3@...

841 2 user4-lastname user4-firstname [url removed, login to view] I user4@...

841 5 user4-lastname user4-firstname [url removed, login to view] J NULL

841 4 user4-lastname user4-firstname [url removed, login to view] K NULL

RETURN

386 2 user2-lastname user2-firstname [url removed, login to view] E user2@...

778 2 user3-lastname user3-firstname [url removed, login to view] G user3@...

841 2 user4-lastname user4-firstname [url removed, login to view] I user4@...

Habilidades: SQL

Ver mais: statement structure sql, table data structure, no structure, using data structure, k emails, multi statement sql, sql select order, project statement sql, tree structure query sql, table structure, largest email, write statement sql

Acerca do Empregador:
( 1 comentário ) Wellington, New Zealand

ID do Projeto: #6774136

Premiar a:

EgyProgramer

Simple task, Please communicate with me to start working on this task. Check my profile for previous work Query is ready, just pm me to send it

$14 NZD em 0 dias
(0 Avaliações)
0.0

6 freelancers estão ofertando em média $19 para este trabalho

ibbuzz

A proposal has not yet been provided

$27 NZD em 1 dia
(6 Comentários)
3.7
AlFaresian

I KNOW YOU WILL SEE THAT I AM A NEW FREELANCER BUT I AM NOT A NEW PROGRAMMER :) -------------------------- In fact, i am a database programmer originally :) with experience above 7 years in this field, from the basi Mais

$21 NZD em 1 dia
(1 Comentário)
0.0
Akoula

Hello I will use all my skills as a computer engineer to satisfy you and within the time specified. Also, I will do everything my expertise available to the project. More information, you may contact me Mais

$16 NZD em 1 dia
(0 Comentários)
0.0
saidmohamed11

I am a talented sql Developer with years of experience and educational training. I am willing to work as a team member and also autonomously for your project. I have also worked for many years of my career as a MySql d Mais

$22 NZD in 0 dias
(0 Comentários)
0.0
Asbarr

Hi I can create a single SQL statement that pulls the data easily.Please inform me.Then I can start your work immediately. Have a nice day! Thank you.

$14 NZD in 0 dias
(0 Comentários)
0.0