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

How does the SQL commands flow at the back end?

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

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.

With code snippet

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

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

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)