Data Research in the table

Note: For convenient testing, you can copy the query commands. Replace our data table with your corresponding table name. For each command, we just need to copy and paste it into the query window and click the Run button.

Data Research in the table

  1. We query data of 10 non-duplicate records located in the line_item_line_item_description table
SELECT distinct "line_item_line_item_description"
FROM "costmaster"."monthly_report"
LIMIT 10;
  • Select Run

Data in the table

  1. Query returned results

Data in the table

  1. Perform query 10 records that have column value line_item_line_item_type as Usage
SELECT * FROM "costmaster"."monthly_report"
WHERE "line_item_line_item_type" like '%Usage%'
LIMIT 10;

Data in the table

  1. Query returned results

Data in the table

  1. Display distinct billing periods in the data table
SELECT distinct bill_billing_period_start_date 
FROM "costmaster"."monthly_report"
LIMIT 10;

Data in the table

  1. Query returned results. Results of billing for each month.

Data in the table