Here are the 30 common SQL queries with examples. These cover a wide range of database operations from basic to more advanced. Basic SELECT Queries Filtering and Conditions Aggregations and Grouping Joins Subqueries Data Modification Advanced Queries These queries cover the most common operations you’ll need when working with SQL databases. Each example can be… Read More »
This is so simple 1. Go to your Google + account (https://plus.google.com/). 2. Click on the Profile icon on the Left. 3. If you look at the URL in the address bar, it should look something like this: https://plus.google.com/104653270154306099169/posts 4. The long numerical string in the URL is your Google+ ID. Here is CoderzHeaven’s from… Read More »
When you are working on an Android application that stores data in a SQLite database.There arise many questions like where does this database file get stored on the filesystem ? How can we access the database? I will give solution to all these problems. I created the SQLite database from my previous post about Using… Read More »
If you want to round a decimal number using SQL, use the ROUND() function of SQL. Syntax: SELECT ROUND(column_name,decimals) FROM table_name eg: SELECT itemName, ROUND(Price,2) as Price FROM Purchase It will select itemName and Price from the table ‘Purchase’ and will Round the Price with 2 decimal places. 