I have this excursie
Write the query, showing prices of all products in one column with the following condition: "The price [Product Na开发者_如何学JAVAme] is [Price] lv.
The table looks like this
If I understood your question correctly, what you are looking for is the concatenation operator ||
You can produce the product name and price in one column like this
SELECT 'The price of [' || PRODNAME || '] is [' || PRODAJNACENA || '] lv'
FROM your_table_name;
精彩评论