Home / Programming and Reporting

Programming and Reporting

Joins in SQL

sql

Joins The Join Scenario All the data is not arranged in a single table Relevant homogenous data is stored in corresponding tables Order Details data has productCode Products data has product details for a given productCode. There are many tables in the database which has some connection with some other …

Read More »

104.1.4 Conditional operators in Python

 In this post we will go through some commonly used conditional operations. if-then-else statement for loop break in for loop If-Then-Else statement If Condition In [100]: age=60 if age<50: print("Group1") print("Done with If") Done with If If-else statement In [101]: age=60 if age<50: print("Group1") else: print("Group2") print("Done with If else") Group2 Done …

Read More »