Category : SQL
SQL related questions
What is the use of FETCH command? OLA interview question
Question
TheDataMonk
SQL Query Output | EXL interview question
Question
TheDataMonk
select case when null=null then ‘Amit’ else ‘Rahul’ end from dual
in progress
2
SQL
55 years
14 Answers
2060 views
Grand Master
Help me create a table with all the employee Names and Manager Names. SQL OYO interview Questions
Question
TheDataMonk
Employee_Name Employee_Id Manager_Id
A 1 2
B ...
in progress
4
SQL
55 years
18 Answers
1884 views
Grand Master
SQL Interview question
Question
Xtramous
Write a query to get all the student with name length 10, starting with K and ending with z
solved
3
SQL
55 years
25 Answers
3020 views
Contributor
Write a SQL query to find all the student names Nitin in a table
Question
Xtramous
Table is student
column is name
Make sure that you cover all the corner cases
solved
2
SQL
55 years
25 Answers
2944 views
Contributor
Ranking in SQL
Question
Xtramous
We have the following values
10000
10000
20000
30000
30000
30000
What would be the result of row number, rank, and dense rank ?
solved
3
SQL
55 years
21 Answers
2452 views
Contributor
Can you use HAVING command without any aggregate function in SQL?
Question
Xtramous
SQL interview Question | Second Highest Salary – Ranking
Question
TheDataMonk
Write a SQL query to get second highest query using Ranking
in progress
2
SQL
55 years
27 Answers
2837 views
Grand Master
SQL interview Question | Second Highest Salary – Method 1
Question
TheDataMonk
Write a SQL query to get second highest query using sub query
in progress
0
SQL
55 years
33 Answers
3603 views
Grand Master
SQL interview question | Write the query
Question
TheDataMonk
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
16
SQL
55 years
46 Answers
5156 views
Grand Master