Register Now

Login

Lost Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Login

Register Now

It will take less than 1 minute to register for lifetime. Bonus Tip - We don't send OTP to your email id Make Sure to use your own email id for free books and giveaways

Category : SQL

SQL related questions

Question
Suppose there are two columns Age Name 25   Nitin 30   Amit 27   Rishab 29   Ankush Convert into Name   Nitin.  Amit. Rishab. Ankush Age.      25.       30.      27.        29
in progress 0
55 years 5 Answers 1481 views Grand Master

Question
Write a SQL query to find the 7th highest employee salary from an Employee Table. If that employee is male, shift to the next employee in alphabetical order. Explain your answer.
in progress 0
55 years 1 Answer 912 views Great Grand Master

Question
Emp_id Emp_name Manager_id Dept_id Joining_date Salary 1 Joy 0 Q 1 January, 2018 6000 2 Manu 0 5 5 July, 2019 6000 3 Ajay 1 1 13 August, 2017 2000 13 Akanksha 2 5 16 May,2020 2000 11 Surbhi 2 1 21 July, 2015 2000 9 Louise 1 - 5 September,2018 3000 8 Vishal 3 1 7 June, 2012 3500 7 Chen Lee 2 5 31 July,2018 NULL 3 Apoorva 1 1 29 February,2016 2000 Arrange the Emp_name in alphabetical order in the new table that only has the salary and Emp_name column in it.
in progress 0
55 years 1 Answer 817 views Great Grand Master

Question
Emp_id Emp_name Manager_id Dept_id Joining_date Salary 1 Joy 0 Q 1 January, 2018 6000 2 Manu 0 5 5 July, 2019 6000 3 Ajay 1 1 13 August, 2017 2000 13 Akanksha 2 5 16 May,2020 2000 11 Surbhi 2 1 21 July, 2015 2000 9 Louise 1 - 5 September,2018 3000 8 Vishal 3 1 7 June, 2012 3500 7 Chen Lee 2 5 31 July,2018 NULL 3 Apoorva 1 1 29 February,2016 2000 Employees having the same salary in the table will get a pay raise of 1000. Create a new table with the increased salary of the ...
in progress 0
55 years 1 Answer 725 views Great Grand Master

Question
Emp_id Emp_name Manager_id Dept_id Joining_date Salary 1 Joy 0 Q 1 January, 2018 6000 2 Manu 0 5 5 July, 2019 6000 3 Ajay 1 1 13 August, 2017 2000 13 Akanksha 2 5 16 May,2020 2000 11 Surbhi 2 1 21 July, 2015 2000 9 Louise 1 - 5 September,2018 3000 8 Vishal 3 1 7 June, 2012 3500 7 Chen Lee 2 5 31 July,2018 NULL 3 Apoorva 1 1 29 February,2016 2000 This table might have some duplicate records. Try to locate them and keep only a single copy in the table.
in progress 0
55 years 1 Answer 624 views Great Grand Master

Question
Emp_id Emp_name Manager_id Dept_id Joining_date Salary 1 Joy 0 Q 1 January, 2018 6000 2 Manu 0 5 5 July, 2019 6000 3 Ajay 1 1 13 August, 2017 2000 13 Akanksha 2 5 16 May,2020 2000 11 Surbhi 2 1 21 July, 2015 2000 9 Louise 1 - 5 September,2018 3000 8 Vishal 3 1 7 June, 2012 3500 7 Chen Lee 2 5 31 July,2018 NULL 3 Apoorva 1 1 29 February,2016 2000 Get the Emp_id for employees whose Dept_id is either invalid or not present in the database.
in progress 0
55 years 2 Answers 915 views Great Grand Master

Question
Emp_id Emp_name Manager_id Dept_id Joining_date Salary 1 Joy 0 Q 1 January, 2018 6000 2 Manu 0 5 5 July, 2019 6000 3 Ajay 1 1 13 August, 2017 2000 13 Akanksha 2 5 16 May,2020 2000 11 Surbhi 2 1 21 July, 2015 2000 9 Louise 1 - 5 September,2018 3000 8 Vishal 3 1 7 June, 2012 3500 7 Chen Lee 2 5 31 July,2018 NULL 3 Apoorva 1 1 29 February,2016 2000 Write a query to find employees who have completed more than 2 years in the company. Create a separate table containing Emp_id, salary and Joining ...
in progress 0
55 years 2 Answers 963 views Great Grand Master