"select <<column_names>> from
<<table-name>>;
If we want to see the data available in ledger-name of Ledger-Master table, then we shall give the syntax as "select ledger_name from ledger_master;" and this will retrieve data and display as follows:
11.01 How to display one column from a table
SYNTAX:
select ledger-name from ledger-master; RESULT:
LEDGER-NAME
cash account sales account
Generally, the column title or Heading label will be derived from the column-name itself, If we need the Tittle 1 column-heading differently we shall add the "as ledger" after column_name but before "from".