We have two columns(Revenue and Cost Price) in a table like below, get me the Profit column Revenue       Cost Price        Profit 100                  Null            ...

With coding example

Write a SQL query to get second highest query using sub query

How does the SQL commands flow at the back end?

Table is student column is name Make sure that you cover all the corner cases

Write a query to get all the student with name length 10, starting with K and ending with z

Write a SQL query to get second highest query using Ranking

A bit tricky, do give a try

We have the following values 10000 10000 20000 30000 30000 30000 What would be the result of row number, rank, and dense rank ?

Write Query

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.

Join interview question

SELECT ‘NITIN’+1 SELECT ‘NITIN’+’1’ SELECT(SELECT ‘NITIN’) SELECT ‘1’+1 SELECT 1+’1’

select case when null=null then ‘Amit’ else ‘Rahul’ end from dual

Explain with any example code

Employee_Name Employee_Id Manager_Id A                                1                           2 B              ...

Explain with proper example

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.

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'

With code snippet

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

Give a couple of partitioning examples

Suppose in class, you have 3n boys and 2n girls with their names tabulated along with their weight and gender. Write a SQL query to separate students alphabetically who are over-weight (55kg for girls, 75kg for boys)

How to fetch alternate records(even rows) from a table?