## Count of duplicate rows in SQL

Question
I have a table student with only one column i.e. Roll No. The values in the table are 10 20 10 10 20 There are in total 3 repetitive values i.e. 10 is repeated two extra times and 20 is repeated one ...
solved 6
2 years 62 Answers 1837 views Grand Master

## SQL interview question | Write the query

Question
We have two columns(Revenue and Cost Price) in a table like below, get me the Profit column Revenue       Cost Price        Profit 100                  Null            ...
solved 8
3 years 43 Answers 3382 views Grand Master

## Statistics Basics

Question
The mean of a distribution is 20 and the standard deviation is 5. What is the value of the coefficient of variation?
in progress 2
3 years 43 Answers 3340 views Contributor

## What do you mean by mutable and immutable data type? Explain

Question
Why did you ask a definition here? Well, it's very important to understand the concept of mutable and immutable data types. Any good product based company will love to play with mutable and immutable indexed and unindexed ordered and unordered ...
solved 2
2 years 37 Answers 1299 views Grand Master

## What is the use of OFFSET command?

Question
With coding example
solved 6
3 years 34 Answers 3103 views Grand Master

## SQL interview Question | Second Highest Salary – Method 1

Question
Write a SQL query to get second highest query using sub query
in progress 0
3 years 31 Answers 2429 views Grand Master

## Statistics Basics 3 | Interview Question

Question
According to the empirical rule, approximately what percent of the data should lie within μ±2σ?
in progress 0
3 years 29 Answers 1752 views Contributor

## What is the order of execution of SQL commands?

Question
How does the SQL commands flow at the back end?
solved 5
3 years 27 Answers 3879 views Grand Master

## SQL interview Question | Second Highest Salary – Ranking

Question
Write a SQL query to get second highest query using Ranking
in progress 2
3 years 27 Answers 1952 views Grand Master

## Can you use HAVING command without any aggregate function in SQL?

Question
A bit tricky, do give a try
solved 1
3 years 27 Answers 3813 views Contributor

## How much is the annual income of a beggar in Bangalore?

Question
Guesstimate
solved 6
3 years 26 Answers 3082 views Grand Master

## Statistics Basics 2 | Interview Question

Question
Which of the following describe the middle part of a group of numbers? a. Measure of Variability b. Measure of Central Tendency c. Measure of Association d. Measure of Shape
in progress 0
3 years 26 Answers 1476 views Contributor

## Write a SQL query to find all the student names Nitin in a table

Question
Table is student column is name Make sure that you cover all the corner cases
solved 1
3 years 25 Answers 2048 views Contributor

## SQL Interview question

Question
Write a query to get all the student with name length 10, starting with K and ending with z
solved 0
3 years 25 Answers 1963 views Contributor

## How would you explain the concept of p-value to a layman ?

Question
In simple terms
solved 2
3 years 24 Answers 2056 views Grand Master

## Demand and Supply increased by 10% but total booking was down by 10% for a particular week, Why?

Question
I work at Uber and found out that for a particular week, number of drivers who signed up for the service increased by 10% and so was the increase in the number of users using the app. But, the number ...
solved 3
2 years 24 Answers 1008 views Grand Master

## What is the difference between xrange and range in Python?

Question
in progress 0
3 years 22 Answers 1361 views Contributor

## SQL Interview Questions | Alternate Rows

Question
You have data of people having applied for a lottery ticket. The data consists of their name and ticket number. You have to choose winners by selecting the people present in the alternate rows (first winner starting from row number ...
in progress 3
3 years 21 Answers 4746 views Great Grand Master

## Suppose you have 10 samples, where 8 are positive and 2 are negative, how to calculate Entropy (important to know)

Question
A bit mathematical
in progress 1
3 years 21 Answers 1384 views Grand Master

## What is the difference between forecasting and prediction?

Question
Both of these terms look similar
solved 1
3 years 21 Answers 1765 views Grand Master

## Find all the students who either are male or live in Mumbai ( have Mumbai as a part of their address).

Question
Write Query
in progress 0
3 years 21 Answers 1361 views Grand Master

## Ranking in SQL

Question
We have the following values 10000 10000 20000 30000 30000 30000 What would be the result of row number, rank, and dense rank ?
solved 1
3 years 21 Answers 1770 views Contributor

## Very briefly explain the assumptions of Linear Regression

Question
This might look like a standard subjective question but any interviewer will assume that you know at least Linear and Logistic Regression irrespective of whether it's mentioned on your resume. This is the first question you start with. Do not copy ...
solved 1
2 years 20 Answers 685 views Grand Master

## SQL Interview Questions | Common Data

Question
Write a query for collecting the names of children who pursuing their graduation in their residential city. NAME AGE ADDRESS COLLEGE ……. …… ….. ….. (Hint- Look for the common city name in the columns of ADDRESS and COLLEGE) Example Nitin 26 Patna Patna Ankit 27 Bangalore Pune Result - Nitin
in progress 3
3 years 20 Answers 4857 views Great Grand Master

## Help me create a table with all the employee Names and Manager Names. SQL OYO interview Questions

Question
Employee_Name Employee_Id Manager_Id A                                1                           2 B              ...
in progress 4
3 years 18 Answers 1224 views Grand Master

## Amazon Interview Question | What percentage of value lies between Mean and one Standard deviation(both positive and negative)

Question
.
solved 0
3 years 18 Answers 2695 views Grand Master

## Is set an indexed and ordered data type? If not then how do you actually access data from a set?

Question
I have a set with 4 values i.e. A,B,C, and D If I print the set again after assigning the values, will it show the values in the same order? If the values are not indexed then how to access these values?
solved 0
2 years 18 Answers 562 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
3 years 18 Answers 1766 views Grand Master

## Difference in the formula of variance calculated for population and sample, Why?

Question
If you don't understand the question, then google it. Explore, what is variance, sample, population, etc.. Once you understand the concepts then come back to the question. The question checks your concept of degree of freedom and whether you have understood ...
solved 0
2 years 18 Answers 1018 views Grand Master

## SQL output question | The Moonfrog Lab interview question

Question
SELECT ‘NITIN’+1 SELECT ‘NITIN’+’1’ SELECT(SELECT ‘NITIN’) SELECT ‘1’+1 SELECT 1+’1’
solved 3
3 years 18 Answers 1518 views Grand Master

## Calculate the cumulative multiplication

Question
Calculating sum is somewhat easy(though we will surely this in another question). We have 4 rows in a table T with column x 2 3 5 10 Output 2 6 30 300
solved 3
2 years 18 Answers 1119 views Grand Master

## Can you join two table without any common column?

Question
Join interview question
in progress 3
3 years 17 Answers 1881 views Grand Master

## Lowe’s Interview Questions | Query I

Question
Name Designation Joining_Date Salary Ashutosh Singla HR 2019-12-15 80,000 Chandan Garg Admin 2019-10-09 60,000 Himanshi Kaur HR 2019-03-13 75,000 Mohit Dharm HR 2019-05-27 85,000 Meena Batra Accountant 2019-07-11 50,000 Omkar Singh Accountant 2019-01-05 45,000 Pratham Garg Admin 2019-05-27 65,000 Rakesh Sharma HR 2018-06-30 75,000 Sharadha Gupta Accountant 2019-09-18 50,000 Demonstrate how to write a query to show details of an HR whose name starts with M.
in progress 1
3 years 17 Answers 1962 views Great Grand Master

## Define Confidence interval in a very layman manner with example

Question
Confidence interval is something for which you can get N number of definitions, but what really matters is whether you understand the concept or not. Try to take any simple real life example and explain the concept. These are the basic questions ...
solved 0
2 years 16 Answers 505 views Grand Master

## Explain Missing Value Treatment by mean,mode, median, and KNN Imputation

Question
What is missing value treatment
solved 1
3 years 16 Answers 3224 views Grand Master

## You want to buy a restaurant in Gurgaon, you have the sales data of last 6 months but you do not have any survey. How would you come up with a price for this restaurant

Question
You plan to buy a restaurant at a price of 80 lac in Cyber City. You have to sales data of the last 6 months. You can assume any valid sales data along with that you also have employees data.
solved 0
2 years 15 Answers 668 views Grand Master

## SQL Query Output | EXL interview question

Question
select case when null=null then ‘Amit’ else ‘Rahul’ end from dual
in progress 2
3 years 14 Answers 1369 views Grand Master

## What is the difference between COUNT(*) and COUNT(ColName)?

Question
Explain with any example code
solved 1
3 years 14 Answers 1556 views Grand Master

## Write a Python program to take a number and check if it’s a palindrome or not

Question
Now the trend has changed a bit, interviewer do not shy away from asking basic python programs. 12321 12345 Palindrome Non-Palindrome
solved 0
2 years 14 Answers 620 views Grand Master

## Explain type 1 error in simplest terms

Question
confusion matrix
solved 0
3 years 14 Answers 1336 views Grand Master

## What do you mean when I say “The model has high accuracy in Training dataset but low in testing dataset

Question
Can you give an example?
solved 0
3 years 13 Answers 905 views Grand Master

## Q1 | Guess the question

Question
All you have to do is to go through the code and comment the question for which the following is an answer of SELECT matchid, player FROM goal WHERE teamid = 'GER'
in progress 2
2 years 13 Answers 1192 views Grand Master

## Explain type 2 error in simple terms

Question
Confusion matrix
in progress 0
3 years 13 Answers 1139 views Grand Master

## Define Loss function in the simplest way possible

Question
Where is it used ?
in progress 0
3 years 12 Answers 1060 views Grand Master

## What is indexing in SQL? Meredith India interview question

Question
Explain with proper example
in progress 2
3 years 12 Answers 1979 views Grand Master

## Define R squared error in simple terms

Question
Try not to use a lot of mathematics
in progress 0
3 years 12 Answers 1261 views Grand Master

## What are the metrics to measure the performance of your Linear Regression model? Most asked question

Question
Almost all the interviewer asks this question
solved 0
3 years 12 Answers 2835 views Grand Master

## How do you measure distribution?

Question
Explain or give name of the methods used to measure distribution
in progress 0
3 years 11 Answers 975 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
3 years 11 Answers 1345 views Grand Master

## What is the need to remove multicolinearity ?

Question
What would happen if we don’t remove it?
solved 0
3 years 11 Answers 1302 views Grand Master