Question 1

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 765 views Newbie

Question 2

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 700 views Newbie

Question 3

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 844 views Newbie

Question 4

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 1054 views Newbie

Question 5

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 1375 views Newbie

Question 6

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.

0

SQL 55 years 0 Answers 885 views Member

Question 7

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 960 views

Question 8

Student – Grade

Question

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

0

SQL Anonymous 55 years 0 Answers 924 views

Question 9

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 1733 views Grand Master

Question 10

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 958 views Grand Master

Register Now

Login

Lost Password

Category : SQL