# What are Latest SQL Query Questions for Practice ?

In previous articles i have given different examples of complex sql queries. In this article i will give you SQL Query Questions and Answers for practice which includes the complex sql queries for interviews also. I want to give you different SQL Query Questions for practice which are not only simple but also complex. All these SQL Questions  for Practice are very useful.

Let us consider table named Employee and with using this table write different SQL Queries

Query 1 : List the employee whose employee number is 100.

Simple where clause is used to write this query,

Select * from Employee where employee_Num=100;

Query 2 : List the Employee whose salary is between 50 K to 1 Lac.

Here user needs to use between..and operator or where clause less than and greater than operator,

Solution 1 : Using Between..and operator

Select * from Employee where salary between 50000 and 100000;

Solution 2 : Using operators (Greater than and less than)

Select * from Employee where salary >= 50000 and salary <= 100000;

Query 3 : List the Employees whose name starts with ‘Ami’.

We need to use like operator to achieve this,

Select * from Employees where name like ‘Ami%’;

Query 4 : List the Employees whose name starts with A and surname starts with S.

We need to use like operator to achieve this,

Select * from Employees where name like ‘A%’ and surname like ‘S%’;

Query 5 : List the Employees whos surname contains kar word.

We need to use like operator to achieve this,

Select * from Employees where  surname like ‘%kar%’;

Query 6: List the Employees whose name starts with P,B,R characters.

Select * from Employees where name like ‘[PBR]%’;

Query 7: List the Employees whose name not starts with P,B,R characters.

We can achieve this using two queries,

Solution 1 : Using Not operator symbol

Select * from Employees where name like ‘[!PBR]%’;

Solution 2 : Using Not Operator

Select * from Employees where name not like ‘[PBR]%’;

Query 8 : What is query to fetch first record from Employee table?

We can achieve this using rownum concept of SQL,

Select * from Employees where rownum=1;

Query 9: What is query to fetch last record from Employees table?

We can achieve this using rowid and max function together,

Select * from Employees where rowid = select max(rowid) from Employee;

Query 10 : How to find 2nd highest salary of Employees using Self join?

Select * from Employees a where 2 = select count (distinct salary) from Employee where a.salary <= b.salary;

Query 11 : What is query to display odd rows from the Employees table?

We can achieve this using Mod function,

Select * from(Select rownum as rno,E.* from Employees E) where Mod(rno,2)=1;

Query 11 : What is query to display even rows from the Employees table?

We can achieve this using Mod function,

Select * from(Select rownum as rno,E.* from Employees) where Mod(rno,2)=0;

Query 12 : Find Query to get information of Employee where Employee is not assigned to the department

We can achieve this using not in operator,

Select * from Employees where Dept_no Not in(Select Department_no from Employee);

Query 13 : How to Show the Max salary and min salary together from Employees table?

Select max (salary) from Employees

Union

Select min (salary) from Employees;

Query 14 : How to get distinct records from the Employees table without using distinct keyword.

Select * from Employees a where  rowid = (select max(rowid) from Employees b where  a.Employee_no=b.Employee_no);

Query 15 :How to fetch all the records from Employee whose joining year is  2018?

Oracle:

select * from Employees where To_char(Joining_date,’YYYY’)=’2018′;

MS SQL:

select * from Employees where substr(convert(varchar,Joining_date,103),7,4)=’2018′;

Query 16 : How to display following using query?

*

**

***

We cannot use dual table to display output given above. To display output use any table. I am using Employees table.

SELECT lpad (‘*’, ROWNUM,’*’) FROM Employees WHERE ROWNUM <4;

Query 17: What is SQL Query to find maximum salary of each department?

To achieve this we need to use max function with group by clause,

Select Dept_id,max(salary) from Employees group by Dept_id;

Query 18:How Do you find all Employees with its managers?(Consider there is manager id also in Employee table)

We can achieve this using self join of Employees table,

Select e.employee_name,m.employee name from Employees e,Employees m where e.Employee_id=m.Manager_id;

Query 19 : Display 3 to 7 records from Employee table.

Select * from (Select rownum as ‘No_of_Row’, E.* from Employee E)

Where No_of_Row between 3 and 7;

Query 20 : How to fetch common records from two different tables Employees and Employees1 which has not any joining condition.

To achieve this we need to use intersect operator,

Select * from Employees

Intersect

Select * from Employees1 ;

Query 21 : Write a query to validate Email of Employee.

To achieve this user needs to use Regular Expression function,

SELECT
Email
FROM
Employee
where NOT REGEXP_LIKE(Email, ‘[A-Z0-9._%+-]+@[A-Z0-9.-]+\.[A-Z]{2,4}’, ‘i’);

Query 22 : How to remove duplicate rows from Employees table.

Tip: Use concept of max (rowid) of table. Click here to get concept of rowid.

Select Employee_No FROM Employees WHERE ROWID <>

(Select max (rowid) from Employees b where Employee_No =b.Employee_No);

These are above some most important SQL Query Questions and Answers for Practice. Hope you like this article on SQL Query Questions and Answers for Practice. If you like the article on SQL Query Questions and Answers for Practice kindly comment in to comment section.

## 206 Replies to “What are Latest SQL Query Questions for Practice ?”

1. Raju says:

Hai bro this is raju.i want sql,plsql query’s and answers.do you have please send me.thank you

1. Hey Raju,

Regards,
Amit S

1. ANUP SOGALI says:

send me some view related questions and other complex queries

1. Thanks Anup for comments.I have sent you the interview questions on your mail id.

1. bhanvi says:

Hi can you please send me sql and plsql interview question as well.

2. akhil says:

can u please send me sql interview questions to mail.

3. Sure Abhil..Kindly check your mail

2. Avinash Kale says:

Hi Amit,
I am visiting your site multiple times, can you please share me the pdf/doc related to more complex SQL queries on Joins, Multiple Joins, Union, Union all, Intersect, Substr, Instr, Ltrim, Rtrim and views related questions. Thanks in advance.

1. Sure Avinash!! I will send you information on Email id provided!!!

1. Manikanth says:

Hi Amit,

Hope you are doing good !!

Would it be possible for you share SQL dump so that i can insert data and start practicing the questions and also can you please complex SQL queries on Joins, Multiple Joins, Union, Union all, Intersect, Substr, Instr, Ltrim, Rtrim and views related questions and interview questions for experienced positions.

great work mate, much appreciated. keep doing such blogs. how can i follow all your blogs related to SQl & other technologies like Selenium.

thanks,
MK

1. Thanks for appreciating blog!! I do not have SQL dumps but i sent you SQL Interview questions on your mail id!!

3. Saritha says:

Hi Amit,
I like the way u updated the site regarding queries, could you please share me the pdf related to simple and more complex SQL queries on Joins, Multiple Joins, Union, Union all, Intersect, Substr, Instr, Ltrim, Rtrim and views related questions.

1. Thanks Saritha for good words!!!

I sent you the SQL interview questions on respective mail id!!

1. Sql question more needed

4. surya says:

Hi Amit,

can u please send pl/sql related questions to my mail id..my mail id is surya.future@gmail.com.

Thanks,

Surya

1. Hi Surya,

I have sent you PDF of SQL interview questions on respective mail id.

5. Saif Saiyed says:

Hi Amit,

I request you to please share me related question on multiple joins,inner join full join and also interview related questiion on my personal mail id:saifsaiyed25@gmail.com

This is my humble and kind request to you.

1. Sure Saif .I will share 🙂

6. Rajesh says:

Hi Amit,

Can you please send me the sql & pl/sql related query’s and answers to my mail id.
My mail id is rajanare1@gmail.com

Thanks,
Rajesh

1. Kindy check your mailbox Rajesh for questions

1. SABHAVAT MAHESH says:

bro
plz share me the lab model queries with answers and also interview questions pdf mail id:sabhavathmahesh1805@gmail.com….
thanks,
MAHESH……

1. Sure Mahesh.

7. Ankita singh says:

Hii Amit
Please send me questions on joins,indexes, functions like substr, substring, aggregate functions,set operators and comparison operators,views,grant revoke, transaction command’s ddl and dml commands,clauses like where,group by, having,order by

1. Thanks Ankita for lovely comments…Kindly check the mail id for More SQL Related interview questions.

8. seema says:

Hi Amit,
Thanks for writing these SQL queries, they are very helpful. I have a request. Could you please share with me queries on Joins – inner, self, outer, right, left joins and on Sub-queries. Please.

1. Thanks Seema for lovely comments…Kindly check the mail id for More SQL Related interview questions.

1. Seema says:

Hi Amit,

Thanks for the PDF on interview questions. But I want Sql queries with answers on Joins and SubQueries. Could you please share me that. This will be very helpful. Thanks

1. Hello Seema,

Thanks for your comments. You can refeer following links for the questions related to joins and subqueries:

Hope this helps !!

Regards,
Amit S

1. Sure Rajesh….:)

9. Deepak Srivastava says:

Hi… Amit
Your Question related to SQL very helpful for me. That’s a grate good job bro..
Can have you send me the some SQL Query Question in my mail id.

10. Ravi Ranjan says:

Hi Amit,

Could you please share with me more interview questions on SQL and PL/SQL

Regards,
Ravi Ranjan

1. Sure Ravi…I sent you the questions on respective mail id.

11. Hi Amit,

Can you please send me the sql & pl/sql related query’s and answers to my mail id.
My mail id is ygtraghav@gmail.com
Thanks,
Yogita

1. Hi Yogita,

Sure ..I will send toy the SQL interview questions..

Thanks,
Amit

12. send me some more complex Query

1. Sent you interview questions..

Can you please send me sql and plsql interview complex queries with answers

Sent interview questions on your id!!

Regards,
Amit S

1. Hi Jayakumar,

Sent you interview questions on your mail id.

Regards,
Amit s

14. Shibi says:

Awesome , can you please share some more complex queries for data science to my mail email id: sibivarun@gmail.com

1. Thanks Shibi.I have sent you more SQL Query Questions and Answers for Practice for your reference.

15. Raghavendra says:

1. Sure Raghavendra!!! I will share you important SQL Query Questions and Answers for Practice for your reference.

16. Anand says:

hi
i need more question on joins , where clause ,set operators and comparison operators,views,grant revoke, transaction command’s ddl and dml commands,clauses like where,group by, having,order by

17. Avi singh says:

Thanks for this queries
can you please send me sql and pl/sql related interview queries to my mail : manandeepsingh456@gmail.com

1. I sent you interview questions on your mail id..Kindly check!!

18. Shubham says:

Hi
I need questions to JOIN more than two tables to fetch data.

1. Hi Shubham,

Regards,
Amit S

19. Kirti says:

Hi. Can you please provide me with some interview SQL Questions based on the topics :
Join and group by in one query; group by on two variables; sub query, join (left, inner, outer, right) and group by in one script; windows function such as partition and rank; use Case statements, use update query, append query, partition function, dense rank.

1. Sure!!! Kirti!!! I will send you all kind of interview questions

20. kush kaushik says:

can you please send me sql server related interview queries to my mail : kush.kaushik87@gmail.com
thank you

1. Sure Kush!!! I will send you interview questions !!

21. Mini says:

Hi Amit, Could you please share the interview question with me on email id: mrinalini8june@gmail.com

1. Sure Mini!! Sent you interview questions on your mail id!!

22. Gaurav says:

Kindly send good joins questions and basics of PLSQL..i will be grateful to you…

1. Sure Gaurav! I have sent you questions gaurav!!

23. Suganesh says:

Hi Amit,
Can You send some interesting select statement queries , joins, views, store procedure, constraints, operators and cte queries. Maximum i need all kind of SQL Server Queries.
And this is my mail id: suganeshbaskar@gmail.com

1. Sure Suganesh!!! I have sent you questions…

24. Sanjeev says:

Hi Amit,

Thank you for posting this. Can you please send me interview questions as well for SQL? My email id is sanjeevjoon.kumar@gmail.com. Thanks

1. Hello sanjeev,

I have sent you SQL Query Questions and answers for practice in your email id.

Regards,
Amit S

25. Charul says:

Can you plz send me the oracle sql question with answer for practice… Thanks

26. Dipanjan says:

Hello Amit,

Can you please send me the SQL interview questions. It would be great if could share SQL query related questions as well. Thanking you in advance.

Email: dipanjannet@gmail.com

27. Tarun Duggal says:

Hi Amit,
Thanks for sharing the above. Can you please also mail me interview questions and answers for SQL? My email id is tarunduggal2@gmail.com. Thanks

1. sent you interview questions on your mail id..

1. harish kumar says:

hi amit can u pls share some IQ questions for sql related gonna attend interview on cts tomorow
share me some documents to this mail id: glenhari13@gmail.com

28. Joshua Roberts says:

Thank you for posting this. Can you please interview questions for SQL to my email ID? Thank you!

29. prakash says:

Hello Amit,

Thanks for the above queries. Can you email me some SQL beginner level and advanced level queries, please? email id: prakash.sharma0912@gmail.com.

Thanks.

1. Hello Prakash,

I sent you interview questions on your mail id.

Regards,
Amit S

30. Shree says:

Good job! Can you please send me SQL interview questions, especially complex and advanced to moderabella1@gmail.com ?

1. Sure Shree!!1

I sent you SQL interview questions on your mail id.

1. Sure Leela.

Kindly check inbox.

31. Ravi Agarwal says:

Hi bro,
This is Ravi.
I want sql,plsql query’s and answers with their tables for practice

1. Sure ravi..Kindly check your inbox…

32. Priyanka says:

hey , ur blog is very nice. can u please share me some more queries on Joins as i m a beginner and preparing for SQL interviews.

1. Shared you interview questions

33. Sudesh says:

Hi Amit,

Could you please send me some PL/SQL and SQL interview questions on my email – reach2sudesh@gmail.com.

1. I sent you more interview questions..Kindly check your inbox..

34. Sagar Garg says:

Thanks for the above queries. Can you email me some SQL beginner level and advanced level queries, please?
email id: sagargarg526@gmail.com.

1. Sure sagar..Kindly check your inbox…

35. rohit sharma says:

Hi Amit,
Great work Amit.
I want Sql queries with answers on Joins and SubQueries. Could you please share me that.
This will be very helpful. Thanks

1. Sure Rohit ..Kindly check your mail for SQL Queries on Joins…

1. I have sent mail of SQL interview questions on your mail id.. Kindly check and confirm!!

36. Dawn says:

Thanks for publishing this! Can you email me some SQL beginner level and advanced level queries and tables to practice, please?

37. Manaswi says:

Plz send me questions on sub queries and joins

1. Sure Manaswi..:)

38. Manaswi says:

Hai, this is very useful queries, can you please give some more queries on joins, sub queries and date related queries…..

1. Sure Manaswi 🙂

39. Bhawna Tyagi says:

Hi,

Thanks,
Bhawna

40. Pondala Chaitanya says:

Hi Amit,
First of all i want to appreciate you because the way you are helping others is very much helpful to their career growth.
Can you email me complex SQL queries of all topics from beginner level and advanced level , please?
Email id: chaitanyapondala@gmail.com

1. Thanks for your appreciation 🙂

41. Lavesh says:

Hello Amit,

Thanks for helping us.
Could you please send me SQL questions for joins, views, subqueries, CTE, Rank, dense rank, aggregations.
I want some scenario based questions for good practice.

1. Thanks for good words Lavesh 🙂

42. Malcom Marshel M says:

Hi,
Can you kindly provide complex sql question with answer and also provide SQL beginner level and advanced level queries and tables to practice.

1. Hi Malcom ,
I sent you SQL Query Questions and Answers for Practice. Kindly check it.

Regards and thanks,

43. Hi Amit,
plz send me sql,pl/sql question and answers.

44. harish kumar says:

hi sir
can u please share some query related question both sql and plsql

45. kiran k says:

Good job and thank you very much Amit! Can you please send me SQL interview questions, especially complex and advanced to kiranm.mudradi@gmail.com ?

1. Thanks kiran for good words..Kindly check your inbox.

46. Sana Saeed says:

Please share complex queries and joins multiple joins and all of that complex interview questions

1. Sure Sana 🙂 Kindly check your inbox 🙂

47. Sudha says:

Hi sir, can I know more sql queries which are frequently asked in interviews and complex queries

1. Sure Sudha..I sent you interview questions.

48. Ketki Keskar says:

Hello Amit, can you please send some complex join related questions on the given email id for practice purpose with some example?

1. Sure Ketaki 🙂 I sent you interview questions for practice 🙂

49. Sir,i want real live e commerce interview questions for the data ananlyst profile.can you help me i am fresher

1. Sure..Sent you mail 🙂

50. Lorenz Joseph says:

Hi Amit, can you send me advanced SQL queries and solutions to prepare for mid-level SQL developer hands-on interviews.

1. sure Lorenz 🙂 Sent you interview questions 🙂

51. sruthi says:

Hi Amit,
Would you send me some interview questions on sub queries, joins,group by,having, limit ans also time and date types such as sql query to fetch recently added records etc,.

Thanks

1. Sure Sruti.. I sent you links on your mail id 🙂

52. Narasimha Reddy B says:

Hi Amit S,
Thank you.
You providing this SQL quries
Could you plese send most interview SQL quries and all DDL ,DCL and DML commnds in pdf type.

1. Sure Narasingha kindly check your inbox for the same 🙂

53. Swapnajit says:

Hi Sir
Can you send me some Complex SQL interview query question to my email id swapk2011@gmail.com

1. Sure Swapnajit. I sent you interview questions

54. ManiMaran says:

hi sir can u send most complicated joins subqueries like documents

1. Sure Suresh 🙂

1. mani maran says:

still i didnt get any documents.so can u pls send documents like joins and subquery related quetsions and solved answers.

1. Sure Mani.

55. NBALAJI says:

Hi Amit,
Can you send me the sql interview questions to my mail id ?

1. sure . Nbalaji..Sending you SQL interview questions 🙂

56. Chintan says:

Hi Amit,

Very nice details about SQL interview questions, which may look easy to answer but need little efforts to derive accurate query. This gives really good thought process on how to think formatting queries to such questions. Really useful brother!! Could you share more similar and more complex interview questions on sql queries (related to SQL joins and other topics) on my email?

Also, for question no.14 above, little doubt how outer table a will be accessible in the inner query as it will be executed first? May be i am missing something, so want to clarify.

1. You are correct chintan about 14th question. For any clarification you can write on complexsql@gmail.com.

I sent you more complex sql queries link 🙂

1. Chintan Desai says:

Great…thank you!!

1. Most Welcome Chintan.

57. Sunil Sharma says:

Thank you, could you please send all the queries to me i am in dire need of practice, please.

1. Sure Sunil.

I sent you interview questions.

58. Vinayak Tegginamani says:

Hi Amit,

I really liked the interview questions on queries, for which my wife is currently searching for. This material will really help her a lot for her preparation. Could you please share more Oracle SQL interview questions for her to prepare more.

1. Thanks Vinayak for your nice words send you interview question 🙂

59. rajesh says:

Amit, Appreciate your great work and patience. Could you please send me complex SQL and plsql queries with answer.my mailid rajesh_k987@YAHOO.COM

1. Sure Rajesh..Kindly check your inbox

60. Sahithi says:

Hi Amit ,
Can you please send me more complex sql queries with relevant solutions.

1. sure Sahithi..I sent you on your mail id

61. Gowtham says:

Hi,

Could you please share the Sql, plsql complex scenario question.

1. Sure Gowtham,

I will send you SQL Query questions and answers for practice.

62. Jasmine says:

thanks for the questions could you please share more complex queries with solutions

Thanks

1. Jasmine- I have sent you interview questions on your mail id.

63. Rashmi says:

Hi Amit,

Thanks for the questions for practising . Its really helpfull. will u send me the complex and different queries on different topics on my email id please…..

1. I sent you more complex sql queries on your mail id.

64. cm says:

Hi ..this is really helpful. Can you send me questions and answers PDF to cmsrd2629@gmail.com ? Also what is the schema and table structure that you are using for these questions. ?

1. sure ..check inbox

65. subbu says:

hai amit,
can u please send me all the sql,plsql qureies to my mailid
thanks

1. sure Subbu.

Kindly check your inbox for the same.

66. DIVYA K says:

Hi Amit,

Thanks for the questions for practicing . Its really helpful. will u send me the complex and different queries on different topics on my email id please…..

1. Sure Divya. Kindly check your inbox for more complex and different query questions.

67. Sirisha Bhonsley says:

hi,
can you plz send the interview questions of sql complex queries, sub queries , joins(inner,left,right,full outer).
here is my email id siri.bhonsle@gmail.com

Thanks,
sirisha.

1. Rajesh K says:

Hi Amit,
Can you send interview questions of sql complex queries, sub queries , joins(inner,left,right,full outer) to this email raz4rent@gmail.com
Thanks,
Rajesh K

1. sure Rajesh I will share you different queries.

68. Raj says:

Hi Amit,
Thanks for sql questions, please share inner queries /sub queries, Joins and more common SQL interview problems to my email
raz4rent@gmail.com
Regards,
Rajesh K

69. Vishesh says:

Hi Amit
First of all so much thanku for the provided above queries for practice.
Can you please share some more questions (focus more on different joins) for practice on my mentioned email id , It will be very helpful.

1. Thanks vishesh for good words.. Sent you interview questions.

70. Ravinder says:

Hi,
Can you kindly provide complex sql question with answer and also provide SQL beginner level and advanced level queries and tables to practice.
my gmail id : ravin.kalkal@gmail.com

1. Sure Ravinder…

71. Narayana says:

Hi Amit,

Nice blog and very good information.
Thanks a lot

Can you please share me few more complex sql queries so that it helps me a lot.

1. Thanks for good words Narayana 🙂

72. Shiv says:

Hi Amit, My name is Shiv. I just download sql. I am trying to do some practice here but I need a database for this practice. can you please send me link to get database for practice .

1. You will get trial version on oracle or microsoft site

73. Charan says:

Hi amit,
Thanks for the above help. Is there anyway you could email me the list of complex tables, query questions and answers to my email id charan.annam813@gmail.com

Thank you very much for this help

1. Hello Charan,

Sure Charan. I will share information with you.

Regards and thanks,

Hi Amit,

Can you provide me SQL topicwise all sql solved queries for practise?
Or pdf which have number of solved queries?

75. Hira says:

Hi Amit,

I request you to please share me related question on ,inner join, outer join and ( insert into, update, delete) and aggregates functions, range on my personal mail id: hiramazhar1717@gmail.com

This is my humble and kind request to you.

1. Sure Hira…
Joins Interview Questions : http://www.complexsql.com/sql-joins-interview-questions/http://www.complexsql.com/category/this-category-includes-sql-interview-questions/
http://www.complexsql.com/pl-sql-examples/.http://www.complexsql.com/unix-scripting-interview-questions/
http://www.complexsql.com/etl-testing-interview-questions/

Regards and thanks,

76. Arpit Jhanwer says:

Hi,

Please provide sql queries with explanation.

77. SOWMYA S says:

Hi Amit,
can you please share me the pdf/doc related to more complex and simple SQL queries on Joins, Multiple Joins, Union, Union all, Intersect and views,sub queries, keys and command related questions. Thanks in advance.

1. Yes Sowmya…
Joins Interview Questions : http://www.complexsql.com/sql-joins-interview-questions/http://www.complexsql.com/category/this-category-includes-sql-interview-questions/
http://www.complexsql.com/pl-sql-examples/.http://www.complexsql.com/unix-scripting-interview-questions/
http://www.complexsql.com/etl-testing-interview-questions/

Regards and thanks,
Amit S

78. Pranati says:

Can you send me sql queries based on views,stored procedure,triggers,functions,indexes?

79. Vidushi says:

Hi Amit
Request you to please share pdf on Starvidushijain@gmail.com

Thanks
Vidushi

1. Thanks vidushi for your good words!

80. Fazil says:

i want to find an answer for this
1. consider the customer data base given below.
customer(custNo:int,custname:string,state:char(2),phone:number)
item(itemno:int,itemName:string,itemprice:float,Qtyonhand:int)
INVOICE(invno:int,invdate:date,custno:int)
invoiceitem(invno:int,itemno:int,qty:int)

create the above tables by properly specifying the primary keys and the foreign keys

enter appropriate number of tuple(minimum3)for each table.

1.find all customer whose names starts with letter E
2.count the number the number of items ordered in each invoce.
3.display the names of items ordered in invoice number 1001 using subquery.
4.create a simple view with item name and item prices only.
5.sort all item in descending order by their price.

1. Sure.

I will check the questions and let you know the detailed level queries

81. Syed says:

Hi Amit,

Thanks for such informative questions, can u plz provide some more questions and solutions for multiple joins, with clause usage, and more complex queries with more joins.
sn.haque136@gmail.com

1. Sure ..Kindly check your inbox

82. devmak says:

can you please share sql interview questions to email : devmakd@gmail.com

1. Sure Devmak..Kindly check your inbox..

1. Hi Bhuvesh,

We have sent the SQL queries to your id.

Regards,
Amit S

83. Chandan Kumar says:

Hi Amit,
Can you send me some Complex SQL interview query question to my email id kuchanda9611@gmail.com

thanks,
Chandan

1. Sure Chandan..I will send you interview questions today..

84. Sachin says:

Hello Amit,
Thanks for sharing and it’s really helpful.
Can you please share me the complex SQL queries with examples to my mail I’d
Sac121212@gmail.com

Thanks

1. Sure Sachin . Kindly check the inbox.

85. Pritam Saha says:

Hi, Can u please send me some more questions on SQL and PL/SQL ?

1. Sure Pritam. Kindly check your inbox.

86. Vivek Dutta says:

Hi Amit,

Can you email(vivek.dbg15@gmail.com) me some complex questions on queries related to subqueries(nested,normal,corelated,inline),joins etc so that i can
practice on them?Try mailing me as many as possible.

Regards,
Vivek

1. Sure vivek ..i sent some links on your mail address. May be that will help u.

87. Max smith says:

We have a funding_transactions table:
id| user_id | timestamp | funding_type | amount
Note: funding_type could be direct_deposit, ach_transfer, cash_deposit, check_deposit
Report the daily total amount of direct_deposit per user for the past 30 days
Identify the id, timestamp, and amount of the first ever cash_deposit for all users, null if never had a cash_deposit

1. Select id,user_id,timestamp,funding_type,amount from funding_transaction order by timestamp where funding_type=’Cash_deposit’;
Try to use rank function in above query..
Send me the problem in complexsql@gmail.com