In this article, I will walk you through some of the built-in functions in SQL to work on column values, followed by handling ‘dates’ values present in tables and finally we will work on nested selects and sub-queries. This article is continuation of my previous blog ‘IBM DB2 Cloud Database and SQL : PART 2’, link to which is given below.

In-order to perform mentioned operations, I have added 2 columns in CUSTOMER table, namely ‘ITEM_PRICE’ and ‘ORDER_DATE’ to hold the information of checkout price and the date at which ordered was placed. …


In my last article, I talked about basic DDL and DML SQL commands to Create, Update and Delete table in the IBM DB2 cloud database. I also threw light on use of inbuilt functions such as Distinct, Count and Limit. Please check the article in link below-

In This article, I will focus on retrieving data from database using String Patterns, Ranges and Sets and further explore ‘Order by’ and ‘Group by’ clauses. I will be using ‘Customer’ table from the database which was created in previous article. …


In non-technical terms, one can infer Database as, the place where data is stored or found after being collected from various data sources. Oracle defines database as an organized collection of structured information, or data, typically stored electronically in a computer system. In general, the primary objective of database, is to store the data such a way that it can be accessed, managed and updated with an ease, and the process of doing so with software, built for the stated purpose is known as Database Management System (DBMS). There are various types of databases available to store the data according…


PHP and HTML are popular web development technologies, further CSS adds essence to HTML website by making it look decent and user friendly. All 3 components together can help us build the full fledged dynamic website. PHP, short for “Hypertext Preprocessor” supports all the HTML and CSS tags, on top of that, PHP allows us to hard-code Website with PHP scripts. Hence, with basic knowledge in hand, you can start coding and scripting and eventually create your own website.

Now, the Interesting thing is you can use HTML tags in PHP code file, However, you can’t execute PHP script in…

Asreshashank

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store