SQL Fundamentals

Seite 1

select * from core.price limit 2;

select price_id, base_price, price_id * 1.2 AS derived_id from core.price;

select price_id AS akash_id from core.price limit 2(rename an existing column in resultset)

select price_id, round(price_id * 1.3245,2) AS derived_id from core.price

select price_id || ', ' || price_def_tp_cd || ' ' || created_by_user from core.price limit 4 (concatenate using ||)

select 'SOME TEXT' || price_id || ', ' || price_def_tp_cd || ' ' || created_by_user from core.price limit 4