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

0

SQL

Home/ SQL/Page 4
Buy EBook on TheDataMonk
Subscribe us on YouTube

Top Categories
Data Analyst
Data Scientist
Business Analyst
Business Intelligence Engineer
Data Engineer
Analytics Manager
Service Based Companies
Product Based Companies
Python
Statistics
SQL
Career Guide, Job, Salary
Case Study
Machine Learning
Most Asked Concepts
TDM Books & Products

Category : SQL

SQL related questions

Question
What will be the output of following sql query SELECT     name,         last_name,         salary FROM Salary WHERE salary >    (SELECT AVG (salary)                     FROM Salary);
in progress 0
55 years 1 Answer 971 views Newbie

Question
Q5. Working with the “employees” table, select the data about all individuals, whose first name starts with “Mar”; specify that the name can be succeeded by any sequence of characters.   Emp_id First_name Last_name Sex Hire_date 1 Mark Johnson M 2021-06-27 2 Marcus stoniss M 2020-05-04 S3 Babita Iyer  F 2021-06-18 4 Jethalal Gada M 2019-07-16 5 Neymar Chapel M 2019-08-09 6 Atmaram Bhide M 2018-09-10 7 Daya Gada F 2020-06-07  
in progress 0
55 years 1 Answer 800 views Member

Question
Q4.     Extract the information about all department managers who were hired between the 1st of      January 2020 and the 1st of January 2021.   DEPARTMENT MANAGER Emp_id First_name Last_name Sex 1 Aman Rathore M 2 Gaurav Singh M 5 Goli Beta M 7  Natu Kaka M     EMPLOYEES Emp_id Emp_name Hire_date 1 Aman 2021-06-27 2 Gaurav 2020-05-04 3 Rohit 2021-06-18 4 Vimal 2019-07-16 5 Goli 2019-08-09 6 Shivam 2018-09-10 7 Natu 2020-06-07
in progress 0
55 years 1 Answer 1016 views Member

Question
Q3.you have given a tabled name “Department”.  Write a query to replace “not provided” where there is null in the below table and then show the department manager column.   Dept_no Dept_name Dept_manager D001 Marketing Aman D002 Finance Ashika D003 Human resource Abhishek D004 Production Vivek D005 Research Null D006 Sales Null D007 Customer care Null
in progress 0
55 years 1 Answer 786 views Member

Question
Query the list of CITY names from STATION that does not start with vowels and do not end with vowels. Your result cannot contain duplicates. Input Format The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the western longitude.
in progress 1
55 years 1 Answer 3323 views Newbie