SQL

There are two tables A,B with 5 rows A - 1,2,3,4,5 B - 1,2,3,Null,Null What will be the output when you do -Left -Right -Cross -Inner Join

Using example differentiate between Union, Minus and Intersect. Write code as well

Every email id is like xyg@domain.com    

Use some method other than window function. Write a sample code with self explanatory table and column name

There are multiple methods to get the 3rd maximum salary. Whenever an interviewer asks you to write a query of this nature, it is bound to be followed up by questions like 'Well, this is good but can you think of ...

Following is the table structure, I am running the code at 10 am on 26th May 2021 Driver_id , status, timestamp 123,Logged_in,24/05/2021 7:00 am 123,Logged_out,24/05/2021 19:00 pm 234,Logged_in,25/05/2021 6:00 am 234,Logged_out,25/05/2021 7:00 am 234,Logged_in,26/05/2021 9:00 am   Output 123 - 24/05/2021- 12 hrs 234 - ...

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

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 ...