Register Now

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

SQL

Home/ SQL/Page 5

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

Category : SQL

SQL related questions

Write a query using above tables to find the employee no, name, designation, whose net salary(basic+DA-Deduction) is minimum in the month of June 2011.

Question

Write a query using above tables to find the employee no, name, designation, whose net salary(basic+DA-Deduction) is minimum in the month of June 2011.

in progress 0

SQL 55 years 1 Answer 722 views Newbie

Write a query to find the record, whose join_basic is maximum using employee table.

Question

Write a query to find the record, whose join_basic is maximum using employee table.

in progress 0

SQL 55 years 1 Answer 678 views Newbie

Write a query using above tables to display the Emp_no, name and Experience ( in year and month)from joining date to current date.

Question

Write a query using above tables to display the Emp_no, name and Experience ( in year and month)from joining date to current date.

in progress 0

SQL 55 years 1 Answer 775 views Newbie

Create a table Salary with following column and data and Write a query using above tables to display the Emp_no, name and net salary of each employee of a particular month

Question

Create a table Salary with the following column and data and Write a query using above tables to display the Emp_no, name and net salary of each employee of a particular month

in progress 1

SQL 55 years 1 Answer 994 views Newbie

Create a table employee with following Column, Constraints and Data and Write SQL command to add a new column state in above table and insert the state name (BR,MP,UP, JH,BR,UP)respectively.

Question

1. Create a table employee with following Column, Constraints and Data 2. Write SQL command to add a new column state in above table and insert the state name (BR,MP,UP, JH,BR,UP)respectively.

in progress 0

SQL 55 years 1 Answer 1324 views Newbie

Find the no. of calls for each customer (i.e. call_to) after their first meaningful call

Question

Find out the no. of calls for each customer (i.e. call_to) after their first meaningful call (i.e. call which lasts for more than 30 seconds). The attached snapshot contains the dataset as well as the expected outcome.

SQL 55 years 0 Answers 824 views Member

Past 7 days Rolling Count distinct

Question

I have date & ids in two columns. Ids can repeat on each date and on multiple dates as well. I want to calculate the count distinct ids which are there present for last 7 days with respect to given date. Eg. ...

in progress 0

SQL Anonymous 55 years 1 Answer 908 views

Student – Grade

Question

List the id , marks of all students whose marks doesn't fall under any grade.

SQL Anonymous 55 years 0 Answers 893 views

Q1 | Guess the question

Question

All you have to do is to go through the code and comment the question for which the following is an answer of SELECT matchid, player FROM goal WHERE teamid = 'GER'

in progress 2

SQL 55 years 13 Answers 1676 views Grand Master

Q2| Guess the question

Question

All you have to do is to go through the code and comment the question for which the following is an answer of SELECT id,stadium,team1,team2 FROM game WHERE id = 1012

in progress 0

SQL 55 years 2 Answers 900 views Grand Master

1 … 4 5 6 … 20

Register Now

Login

Lost Password

Login

Register Now

SQL

Top Categories

Category : SQL

Subscribe to our newsletter