Many time we need SQL query which returns data page by page i.e. 30 or 40 records at a time, which can be specified as page size. In fact, Database p…
Unlike Java, Microsoft SQL Server 2008, 2012, 2014, and even the latest version don't have a built-in trim() function, which can remove both lea…
Hello Guys, you might have heard about how useful the EXISTS clause is helpful in writing sophisticated queries. Still, at the same time, I have also…
The SQL is one of the most important skills for any programmer be it a Java, C++, Python, JavaScript, or Ruby developer. Almost 95% of the Java appli…
Though it's not mandatory for Java or Web developers to learn the NoSQL database, the world is moving in that direction, and both Java and Web de…
PostgreSQL is one of the most popular databases after the big three - Oracle, SQL Server, and MySQL. PostgreSQL is commonly known as Postgres and is …
MongoDB is one of the leading NoSQL databases and it was on my radar for a long time but I never get a chance to learn or work on it, but Recently I …
Hello guys, we are already in the first week of New year and everyone is talking about their goals to improve them as a better person, a better progr…
Here is my list of some of the most usefulMySQL commands which I have used in my day to day life while working with MySQL database in Linux. This com…
In last summer, I had to work on a Java project which was using the Oracle database at their backend. The project was a mix of Java code with Oracle …
Write a SQL query to find all duplicate emails in a table named Person. +----+---------+ | Id | Email | +----+---------+ | 1 | a@b.com | | 2 | c@…
Other day, I was looking for a website to execute SQL query online, since I have uninstalled Microsoft SQL Server because of memory and CPU constrain…
The Select command in SQL is one of the most powerful and heavily used commands. This is I guess the first command anyone learn in SQL even before C…