https://community.databricks.com/t5/warehousing-analytics/how-to-get-the-size-of-selected-rows-in-bytes-using-a-single-sql/m-p/109096#M1870 <P>Hi all,</P><P>I have a table named employee in Databricks. I ran the following query to filter out rows where the salary is greater than 25000.</P><P>This query returns 10 rows. I want to find the size of these 10 rows in <STRONG>bytes</STRONG>, and I would like to calculate or retrieve this size only&nbsp;<STRONG>within the same query</STRONG>. How can I achieve this?</P><P>Any help would be appreciated!</P> Thu, 06 Feb 2025 08:13:06 GMT Akshay_Petkar 2025-02-06T08:13:06Z https://community.databricks.com/t5/warehousing-analytics/how-to-get-the-size-of-selected-rows-in-bytes-using-a-single-sql/m-p/109096#M1870 <P>Hi all,</P><P>I have a table named employee in Databricks. I ran the following query to filter out rows where the salary is greater than 25000.</P><P>This query returns 10 rows. I want to find the size of these 10 rows in <STRONG>bytes</STRONG>, and I would like to calculate or retrieve this size only&nbsp;<STRONG>within the same query</STRONG>. How can I achieve this?</P><P>Any help would be appreciated!</P> Thu, 06 Feb 2025 08:13:06 GMT https://community.databricks.com/t5/warehousing-analytics/how-to-get-the-size-of-selected-rows-in-bytes-using-a-single-sql/m-p/109096#M1870 Akshay_Petkar 2025-02-06T08:13:06Z https://community.databricks.com/t5/warehousing-analytics/how-to-get-the-size-of-selected-rows-in-bytes-using-a-single-sql/m-p/109303#M1874 <P>Hi&nbsp;<a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/88335">@Akshay_Petkar</a>,</P> <P>You can try with this query:</P> <P>SELECT SUM(LENGTH(CAST(employee.* AS STRING))) AS total_size_in_bytes<BR />FROM employee<BR />WHERE salary &gt; 25000;</P> Thu, 06 Feb 2025 20:42:42 GMT https://community.databricks.com/t5/warehousing-analytics/how-to-get-the-size-of-selected-rows-in-bytes-using-a-single-sql/m-p/109303#M1874 Alberto_Umana 2025-02-06T20:42:42Z