tencent cloud

Feedback

SELECT Syntax

Last updated: 2022-04-18 15:19:46

    The SELECT statement is used to select data from a table. It selects eligible data from the current log topic by default.

    Syntax Format

    * | SELECT [Column name(KEY)]
    

    Syntax Example

    Select values whose columns (KEY) are remote_addr and method from the log data:

    * | SELECT remote_addr, method 
    

    Select all columns (KEY) from the log data:

    * | SELECT *
    

    SELECT can also be followed by arithmetic expressions; for example, you can query the download speed of log data:

    Download speed (speed) = total number of bytes sent (body_bytes_sent) / request time (request_time)

    * | SELECT body_bytes_sent / request_time AS speed
    
    Contact Us

    Contact our sales team or business advisors to help your business.

    Technical Support

    Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

    7x24 Phone Support