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 0.00 A NULL

335 4 user1-lastname user1-firstname 0.04 B NULL

335 8 user1-lastname user1-firstname 0.30 C NULL

386 3 user2-lastname user2-firstname 0.00 D NULL

386 4 user2-lastname user2-firstname 0.50 E NULL

386 2 user2-lastname user2-firstname 0.00 F user2@...

778 4 user3-lastname user3-firstname 0.60 G NULL

778 2 user3-lastname user3-firstname 0.30 H user3@...

841 2 user4-lastname user4-firstname 0.50 I user4@...

841 5 user4-lastname user4-firstname 0.30 J NULL

841 4 user4-lastname user4-firstname 0.00 K NULL

RETURN

386 2 user2-lastname user2-firstname 0.00 E user2@...

778 2 user3-lastname user3-firstname 0.30 G user3@...

841 2 user4-lastname user4-firstname 0.50 I user4@...

Habilidades: SQL

Ver mais: statement structure sql, table data structure, no structure, c using data structure, k emails, multi statement sql, sql select order, using rets data sql server, write tree structure query sql, project statement sql, tree structure query sql, table structure, card game using java data structure, card game using java data structure gui, largest email, case statement sql column heading, write statement sql, sql query tree structure records

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 [url removed, login to view] inform [url removed, login to view] I can start your work immediately. Have a nice day! Thank you.

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