Em Andamento

SQL Statement Structure -- 2

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

Here are the details:

Select

Distinct ID,

Order1 where order1 is the smallest

Surname, First_Name,

Qual where Qual is the largest,

Details where Qual is the largest,

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

TABLE

ID Order1 Surname First_Name Qual Details 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.50 E user2@...

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

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

Habilidades: SQL

Ver mais: table data structure, no structure, c using data structure, k emails, statement structure sql, multi statement sql, write tree structure query sql, project statement sql, tree structure query sql, table structure, sql query date ascending order day, card game using java data structure gui, sql query find last order date, sql query display descending order, largest email, case statement sql column heading, write statement sql

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

ID do Projeto: #6774576

Premiar a:

abdellatif81

Hello, I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 8 years of experience working around databases and SQL development arou Mais

$28 NZD em 0 dias
(12 Avaliações)
4.4

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

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 sql . I Mais

$27 NZD em 1 dia
(0 Comentários)
0.0
aazc5aazc

I'm familiar with SQL and I can finish your task with quality. I'm familiar with SQL and I can finish your task with quality.

$28 NZD em 1 dia
(0 Comentários)
0.0
rokingrav

A proposal has not yet been provided

$21 NZD em 1 dia
(0 Comentários)
0.0
phongpro

I have 5 years of programming experience. I can help you solve this problem. When you work with me you will feel very comfortable.

$26 NZD in 0 dias
(0 Comentários)
0.0
fahmidaward

Please contact us to discuss the detail of this work. Do you want to do this work directly on your server. Do you have MS Server or Oracle please let us know.

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