Useful tips for everyday
How use distinct and top in SQL? SELECT DISTINCT TOP 2 name FROM [ATTENDANCE] ; In the above query, name is the column_name and [ATTENDANCE]…
Is multi-threading better? When the ratio Overhead / Execution Time is greater than P/2, a single thread is faster. MultiThreading on Single Core CPU :…
How do you improve a recursive function? Bottom-up. Sometimes the best way to improve the efficiency of a recursive algorithm is to not use recursion…
How do you do a Curl POST request? To POST a file with curl , simply add the @ symbol before the file location. Can…
Can you use classes in JavaScript? Classes in JavaScript are a special syntax for its prototypical inheritance model that is a comparable inheritance in class-based…
How do you count lines of code? Cloc can be used to count lines in particular file or in multiple files within directory. To use…
Can I scrape data from IMDB? Yes you can scrape information from IMDB, most information available there are already public and definitely available for you…
Which is the correct way to filter in R? In R generally (and in dplyr specifically), those are: 1 == (Equal to) 2 != (Not…
How do you find the common substring of a string? Check if two strings have a common substring You are given two strings str1 and…
What is the precision of a number in SQL Server? Precision is the number of digits in a number. Scale is the number of digits…