SQL - The Data Monk

Register Now

Lost Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Category : SQL

SQL related questions

BOX8 | SQL Query

Question

Assume the name of table and columns There are two tables with a common column. Which one will take more processing time -Outer Join - Full Outer Join - Cartesian Join

in progress 1

SQL 55 years 4 Answers 1740 views Grand Master

BOX8 | Ranking in SQL

Question

Assume table and columns Get me the name of the lowest salary from each department

in progress 0

SQL 55 years 4 Answers 1320 views Grand Master

Amazon Interview Question | What is NTILE with syntax?

Question

With example and use case

in progress 0

SQL 55 years 3 Answers 1708 views Grand Master

What is the use of IFNULL and ISNULL in SQL?

Question

With example

in progress 0

SQL 55 years 6 Answers 2212 views Grand Master

Important conditions for joining two tables on a key?

Question

Joining two tables

in progress 0

SQL 55 years 4 Answers 2262 views Grand Master

What is Hash Join?

Question

With example

SQL 55 years 0 Answers 1215 views Grand Master

Write a SQL query to find the common records between two tables?

Question

Provide multiple ways

in progress 0

SQL 55 years 3 Answers 5365 views Grand Master

Write the query to remove the duplicates from a table without using a temporary table?

Question

Write query

in progress 0

SQL 55 years 4 Answers 1724 views Grand Master

Get the number of duplicate names and their frequency

Question

Table - Employee Name Nitin Amit Gaurav Nitin Amit Output Nitin - 2 Amit - 2 Gaurav - 1

in progress 1

SQL 55 years 11 Answers 1923 views Grand Master

Extract all the distinct email id domain from all the employee

Question

Suppose there are two columns in employee table i.e. emp id and email get all the unique domains like gmail.com, yahoo.com, outlook.com, etc.

solved 6

SQL 55 years 18 Answers 2740 views Grand Master

1 … 14 15 16 … 20

Products

1 Month Analytics Mentorship Program Original price was: ₹11500.Current price is: ₹9999.
The Data Monk 23 e-book bundle Original price was: ₹6900.Current price is: ₹1999.
2200 Most Asked Analytics Interview Questions Original price was: ₹7999.Current price is: ₹1999.
10 Books to crack Analytics interview Original price was: ₹2999.Current price is: ₹999.
Machine Learning 1200 Interview Questions Original price was: ₹3600.Current price is: ₹999.
30 Days Analytics Course Original price was: ₹1999.Current price is: ₹999.
1250+ Business Analyst Most Interview Questions Original price was: ₹1299.Current price is: ₹899.
Crack Any Data Analyst Interview with 1100 Questions Original price was: ₹1999.Current price is: ₹799.
550 SQL Interview Questions to crack Any Analytics interview Original price was: ₹999.Current price is: ₹499.
Crack your next Data Science interview with 300+ Questions Original price was: ₹499.Current price is: ₹299.