Posts

Showing posts with the label error logic

Featured Post

SQL Interview Success: Unlocking the Top 5 Frequently Asked Queries

Image
 Here are the five top commonly asked SQL queries in the interviews. These you can expect in Data Analyst, or, Data Engineer interviews. Top SQL Queries for Interviews 01. Joins The commonly asked question pertains to providing two tables, determining the number of rows that will return on various join types, and the resultant. Table1 -------- id ---- 1 1 2 3 Table2 -------- id ---- 1 3 1 NULL Output ------- Inner join --------------- 5 rows will return The result will be: =============== 1  1 1   1 1   1 1    1 3    3 02. Substring and Concat Here, we need to write an SQL query to make the upper case of the first letter and the small case of the remaining letter. Table1 ------ ename ===== raJu venKat kRIshna Solution: ========== SELECT CONCAT(UPPER(SUBSTRING(name, 1, 1)), LOWER(SUBSTRING(name, 2))) AS capitalized_name FROM Table1; 03. Case statement SQL Query ========= SELECT Code1, Code2,      CASE         WHEN Code1 = 'A' AND Code2 = 'AA' THEN "A" | "A

Python Function: How to Write Error Logic

Image
Here's an example python user-defined function. Here, you'll know how to write error conditions. The best examples is if and else. I have shared the logic here for your reference. Python is one of the top programming languages. Python does support Functions . While writing functions you also need to consider some errors. Those are called exceptions. I am explaining how to give error logic in a function of Python. Exception-handling means to have logic for error scenarios. Writing exception I will show in a simple Function. In this post I will give you syntax for writing function and exception.  Here is my simple Function that multiplies two numbers. Logic to write Function in Python to Multiply Two Numbers  def product (num1,num2): prod=num1*num2 print( ' The product of the numbers is \t: '+str(prod) Parameters used the Python Function The 'def' means you are defining function with a name of 'product'. In the parameters of 'product', you can s