Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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
Use Where condition in your SQL statement
SQL SELECT OrderNo,
Weight,
CubedWeight,
Pieces,
DeliveryDriver
FROM CourierComplete.dbo.CompletedOrders
Where DeliveryDriver='GTA';
Thank you very much!
Thank you very much!