Transaction and ACID properties: A set of statements executed on a resource or resources applied with ACID properties is known as Transaction. Note: Here database is one resource but resource need not be only database. ACID Properties: …

What is the difference between sub query and co-related subquery: Sub Query: Here inner query gets executed first and based on the result of it the outer query is executed…

Implementation of relationships in sql: We have three types of relationships in SQL. one-to-one; one-to-many; many-to-many…

When should we use GROUP BY clause: When there is a need to aggregate/group values in a column based on some criteria in same/another column then we go for GROUP BY clause. Usage of Aggregate function on column: col_sales: …

Difference between ‘where’ and ‘having’ clause: ‘where’ clause is used to apply a condition on an column directly…

Difference between ‘distinct’ and ‘group by’ clauses: ‘distinct’ keyword is used to remove duplicates…

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s


Mostly technology with occasional sprinkling of other random thoughts


Amir Amintabar's personal page

101 Books

Reading my way through Time Magazine's 100 Greatest Novels since 1923 (plus Ulysses)

Seek, Plunnge and more...

My words, my world...

ARRM Foundation

Do not wait for leaders; do it alone, person to person - Mother Teresa

Executive Management

An unexamined life is not worth living – Socrates


A topnotch WordPress.com site


Just another WordPress.com site

coding algorithms

"An approximate answer to the right problem is worth a good deal more than an exact answer to an approximate problem." -- John Tukey