Showing posts with the label Simple Queries in SQL

Consider the following tables Employee and Salary. Write SQL commands for the statements

Q. Consider the following tables Employee and Salary. Write SQL commands for th…

Give the output of following SQL statement: (i) SELECT MIN(AvgMark) FROM STUDENT WHERE AvgMark

Q. Give the following table:- Give the output of following SQL statements : (…

Give the output of following SQL statements: SELECT COUNT (DISTINCT SPORTS) FROM Club;

Q.     Give the output of following SQL statements: (i) SELECT COUNT (DISTIN…

Given the following table : Give the output of following SQL statement (i) SELECT TRUNCATE(AvgMark) FROM Student1 WHERE AvgMark

Q. Given the following table: Give the output of following SQL statement :…

Write SQL commands for the following on the basis of given table relation Teacher (a) To show all information about the teacher

Q. Write SQL commands for the following on the basis of given table relation Te…

Write SQL commands for the following on the basis of given table GRADUATE (a) List the names of those students who have

Q. Write SQL commands for the following on the basis of given table GRADUATE: …

Write SQL commands for the following on the basis of given table MOV (a) Display a list of all movies with Price over 20 and sorted by Price.

Q. Write SQL commands for the following on the basis of given table MOV : …

Write SQL commands for the following on the basis of given table (a) Select all the PROG type published by BPB from Library.

Q. Write SQL commands for the following on the basis of given table : (a) …

Write SQL commands for the following on the basis of given table STUDENT1 Select all the Nonmedical stream students from STUDENT1.

Q.Write SQL commands for the following on the basis of given table STUDENT1 : …

Write SQL commands for the following on the basis of given table CLUB To show all information about the swimming coaches in the club.

Q. Write SQL commands for the following on the basis of given table CLUB : …

Write SQL commands for the following on the basis of given table SPORTS:

Q. Write SQL commands for the following on the basis of given table SPORTS: …

Write SQL commands for the following on the basis of given table STUDENT:

Q. Write SQL commands for the following on the basis of given table STUDENT: 1…

Write a query that selects all orders (Order table) except those with zeros or NULLS in the amt field.

Q. Write a query that selects all orders (Order table) except those with zeros …

Write a query on the customers table whose output will exclude all customers with a rating 100, unless they are located in Shimla.

Q. Write a query on the customers table whose output will exclude all customers…

Write a query to display the name of employee whose name contains M as first alphabet L as third alphabet.

Q. Write a query to display the name of employee whose name contains 'M'…

Write a query to display the name of employee whose name contains T as the last alphabet.

Q. Write a query to display the name of employee whose name contains T as the l…

Write a query to display the name of employee whose name contains A as third alphabet.

Q. Write a query to display the name of employee whose name contains 'A'…

Write a query to display the name, job title and salary of employee who do not have manager.

Q Write a query to display the name, job title and salary of employee who do no…

Write a query to display employee name and salary of those employee who don't have there salary in the range of 2500 to 4000.

Q. Write a query to display employee name and salary of those employee who don&…

Write a query to display details of employees who are not getting commission from table Empl.

Q. Write a query to display details of employees who are not getting commission…

Load More That is All