xxxxxxxxxx
select cart.Id, cart.UpdatedOnUtc,cart.CreatedOnUtc, cart.RentalEndDateUtc,cart.RentalStartDateUtc, map.Quantity,
cart.CustomerEnteredPrice,cart.AttributesXml,cart.ProductId,cart.CustomerId,cart.ShoppingCartTypeId,cart.StoreId
from AUR_ShoppingCart_WishList_Mapping map,ShoppingCartItem cart where cart.Id = map.ShoppingCartItemId and map.WishListId = '55'
xxxxxxxxxx
This is a good SQL editor:
https://www.tutorialspoint.com/execute_sql_online.php
xxxxxxxxxx
try this online tool, it's free and support multilangs (SQL, MySQL, C, C++, PHP, Node, Deno, ..etc)
https://www.mycompiler.io/new/sql
xxxxxxxxxx
12
Create table sub (sub_id number (3) primary key, sub_name varchar2 (10), Sub_code number (3), sub_id number(3), foreign key (sub_id) references sub (sub_id));
xxxxxxxxxx
123456789101112
create table customers (customer_id[int],first_name[varchar(100)],last_name[varchar(100)],age[int],country[varchar(100)]);
xxxxxxxxxx
12
CREATE TABLE EMPLOYEE(NAME VARCHAR2(20),EMAIL VARCHAR2(20),DOB date);INSERT INTO EMPLOYEE VALUES('ROHAN','rehangmailcom','20');
xxxxxxxxxx
DECLARE @deltaStartRowkey NVARCHAR(255) = (
SELECT PTP.pipelineTaskParameterValue
FROM dwhframework.dbo.pipelineTaskParameter PTP
WHERE PTP.pipelineTaskSID = @pipelineTaskSID
AND PTP.pipelineTaskParameterKey = 'deltaStartRowkey'
)