These are some interview question and answer asked during my recent interview. Oracle interview questions are very important during any programming j…
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…
One of the most common task while writing SQL queries or stored procedure is to find the length of String. Since most of the columns are VARCHAR, you…
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…
Write a SQL query to find all duplicate emails in a table named Person. +----+---------+ | Id | Email | +----+---------+ | 1 | a@b.com | | 2 | c@…
We often need to replace NULL values with empty String or blank in SQL e.g. while concatenating String. In SQL Server, when you concatenate a NULL St…
Hello guys, when it comes to combining two tables in SQL, you can use the JOIN clause. Thre are mainly two types of joins, INNER Join, and OUTER join…
Write an SQL Query to Find Employees Earning More Than Managers The Employee table holds all employees including their managers. Every employee has a…