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.

Login

Register Now

It will take less than 1 minute to register for lifetime. Bonus Tip - We don't send OTP to your email id Make Sure to use your own email id for free books and giveaways

SQL

Home/ SQL/Page 15

Buy EBook on TheDataMonk

Subscribe us on YouTube

Top Categories

Data Analyst

Data Scientist

Business Analyst

Business Intelligence Engineer

Data Engineer

Analytics Manager

Service Based Companies

Product Based Companies

Python

Statistics

SQL

Career Guide, Job, Salary

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 1652 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 1253 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 1652 views Grand Master

What is the use of IFNULL and ISNULL in SQL?

Question

With example

in progress 0

SQL 55 years 6 Answers 2137 views Grand Master

Important conditions for joining two tables on a key?

Question

Joining two tables

in progress 0

SQL 55 years 4 Answers 2180 views Grand Master

What is Hash Join?

Question

With example

SQL 55 years 0 Answers 1150 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 5164 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 1646 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 1842 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 2648 views Grand Master

1 … 14 15 16 … 20

Register Now

Login

Lost Password

Login

Register Now

SQL

Top Categories

Category : SQL

Subscribe to our newsletter