Home Database
Database
Database
Best NoSQL Databases 2021 – Most Popular among Programmers
Programmer - 0
A database is a collection of information that is organized so that it can be easily accessed, managed and updated. Before starting with the most popular...
Database
Top 10 Databases You Should Learn in 2020
Programmer - 0
A database is must need for any software development and which database to choose is one of the main requirement for software architecture. In...
Blogs
Most Popular Database Queries For an Interview
Programmer - 0
Hi Programmers, In this article, we discuss most Popular Database Queries For an Interview.
Do you want to apply at Google, Amazon, Microsoft, Facebook, Apple...
Database
Customers Who Never Order
Programmer - 0
Suppose that a website contains two tables, the tableCustomers and the tableOrders. Write a SQL query to find all customers who never order anything.
Table:...
Database
Delete Duplicate Emails
Programmer - 0
Write a SQL query to delete all duplicate email entries in a table named,Person keeping only unique emails based on its smallestId.
+----+------------------+
| Id | Email...
Database
Rising Temperature
Programmer - 0
Given a Weather table, write a SQL query to find all dates' Ids with higher temperature compared to its previous (yesterday's) dates.
+---------+------------+------------------+
| Id(INT) | Date(DATE) |...
Database
Department Highest Salary
Programmer - 0
The Employee table holds all employees. Every employee has an Id, a salary, and there is also a column for the department Id.
+----+-------+--------+--------------+
| Id | Name...
Database
Swap Sex Field
Programmer - 0
Given a table salary, such as the one below, that has m=male and f=female values. Swap all f and m values (i.e., change all f...
Database
Combine Two Tables
Programmer - 0
Table: Person
+-------------+---------+
| Column Name | Type |
+-------------+---------+
| PersonId | int |
| FirstName |...