Advertisement
Guest User

Untitled

a guest
Mar 27th, 2017
42
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.37 KB | None | 0 0
  1. INSERT INTO STAGING.ASSET (ASSET_ID,ASSET,ASSET_DESC)
  2. values ((SELECT MAX(ASSET_ID) FROM STAGING.ASSET )+ 1 ,'High Yield');
  3.  
  4. INSERT INTO STAGING.ASSET (ASSET_ID,ASSET,ASSET_DESC)
  5. values (SELECT MAX(ASSET_ID)+1 FROM STAGING.ASSET ,'High Yield');
  6.  
  7. INSERT INTO STAGING.ASSET (ASSET_ID,ASSET,ASSET_DESC)
  8. values ((SELECT MAX(ASSET_ID) FROM STAGING.ASSET )+ 1 ,'High Yield');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement