Most Popular Database Queries For an Interview

Most Popular Database Queries For an Interview

Hi Programmers, Do you want to apply at Google, Amazon, Microsoft, Facebook, Apple or any big MNC company? If yes, then must go through below...
SQL vs NoSQL Database

Top 10 Databases You Should Learn in 2018

A database is must need for any software development and which database to choose is one of the main requirement for software architecture. In...
Best NoSQL database 2016 2017

Best NoSQL Databases 2018 – Most Popular among Programmers

Before starting with most popular NoSQL databases. You must have to know about NoSQL databases. Most of the programmer doesn't know that it stands...
Customers Who Never Order

Customers Who Never Order

Suppose that a website contains two tables, the Customers table and the Orders table. Write a SQL query to find all customers who never...
Delete Duplicate Emails

Delete Duplicate Emails

Write a SQL query to delete all duplicate email entries in a table named Person, keeping only unique emails based on its smallestId. For example, after running...
Rising Temprature

Rising Temperature

Given a Weather table, write a SQL query to find all dates' Ids with higher temperature compared to its previous (yesterday's) dates. For example, return the following...
Department Highest Salary

Department Highest Salary

The Employee table holds all employees. Every employee has an Id, a salary, and there is also a column for the department Id. The Department table holds all departments...
Swap Sex Fields

Swap Sex Field

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...
Combine Two Tables

Combine Two Tables

Table: Person Table: Address Write a SQL query for a report that provides the following information for each person in the Person table, regardless if there is an...
Nth Highest Salary

Nth Highest Salary

Write a SQL query to get the nth highest salary from the Employee table. For example, given the above Employee table, the nth highest salary where n = 2 is 200. If there is...

STAY CONNECTED

36,686FansLike
28,876FollowersFollow
331FollowersFollow
2,693FollowersFollow
316SubscribersSubscribe