Showing posts with label Power shell. Show all posts
Showing posts with label Power shell. Show all posts

Tuesday, August 18, 2020

Powershell Fastest and Efficient way to read huge csv file

$row_count = 0 
Get-Content '.\big_file_name_with_path.csv' -ReadCount 2000 | foreach { $row_count += $_.count }
$row_count

Find the Subtasks That Did Not Execute Leetcode

 with recursive CTE as ( SELECT task_id,subtasks_count,1 as result FROM Tasks UNION ALL SELECT CTE.task_id,subtasks_count,result+1 FROM CTE ...