Hello all~ Please help me with a question

[#1]

Hello y'all!

     i have a small question that i want to ask everyone.

This is the code i have right now:

SQL SELECT          OrderNo,

                              Weight,

                              CubedWeight,

                              Pieces,

                              DeliveryDriver

FROM CourierComplete.dbo.CompletedOrders;

this code could pull so many different results, but how do i pull something specific?

if i want only a specific DeliveryDriver, let's say..... DeliveryDriver is GTA, what would the code be??

Thank you very much!

[MayilVahanan · Accepted solution]

HI

SQL SELECT          OrderNo,

                              Weight,

                              CubedWeight,

                              Pieces,

                              DeliveryDriver

FROM CourierComplete.dbo.CompletedOrders where DeliveryDriver='GTA';

or, you want to load all data but restrict the DeliveryDriver is GTA means

Load OrderNo,Weight,CubedWeight,Pieces,if(match(DeliveryDriver,'GTA',DeliveryDriver) as DeliveryDriver;

SQL SELECT   *

FROM CourierComplete.dbo.CompletedOrders

Hope it helps

[CELAMBARASAN]

Use Where condition in your SQL statement

SQL SELECT          OrderNo,

                              Weight,

                              CubedWeight,

                              Pieces,

                              DeliveryDriver

FROM CourierComplete.dbo.CompletedOrders

Where DeliveryDriver='GTA';

[#4]

Thank you very much!

[#5]

Thank you very much!