SQL related questions
What is the use of FETCH command? OLA interview question
Question
SQL Query Output | EXL interview question
Question
select case when null=null then ‘Amit’ else ‘Rahul’ end from dual
in progress
2
SQL
55 years
14 Answers
2172 views
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
SQL
55 years
18 Answers
1969 views
Grand Master
SQL Interview question
Question
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
3134 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
2
SQL
55 years
25 Answers
3044 views
Contributor
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
3
SQL
55 years
21 Answers
2509 views
Contributor
Can you use HAVING command without any aggregate function in SQL?
Question
SQL interview Question | Second Highest Salary – Ranking
Question
Write a SQL query to get second highest query using Ranking
in progress
2
SQL
55 years
27 Answers
2920 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
SQL
55 years
33 Answers
3694 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
16
SQL
55 years
46 Answers
5278 views
Grand Master