Selecting Multiple Columns ?SQL | Sololearn: Learn to code for FREE!

0

Selecting Multiple Columns ?SQL

In sql lesson 4.2,when buying food... How can i use select statement to code?

sql

4/11/2021 8:11:42 AM

any art

5 Answers

New Answer

0

This code SELECT ProductName, ProductionDate, ExpirationDate from Products; Always results in error as the productname values appeared with small first letter ( ex: jogurt instead of Jogurt )

0

SELECT ProductName, ProductionDate, ExpirationDate from Products; this is the answer to the question

0

SELECT ProductName, ProductionDate, ExpirationDate from Products

-1

Syntax of the SQL SELECT Statement: SELECT ​column_list FROM table In the given problem, we have a table named "Products" and from that table, we have to select three columns whose names are given. So, we simply have to select those columns by mentioning them. SELECT ProductName, ProductionDate, ExpirationDate from Products;

-2

Try this code it works!!! SELECT InitCap(ProductName) as ProductName, ProductionDate, ExpirationDate FROM Products;