plz give me a all sql queries and commads questions bcoz tommorow is my board exam of computer class 10
abhijeetpandey103:
noo
tommorow is not board exam of 10 computer
this is very easy question
please delete 2 ans then i tell you
hai computer means i.t
Tomorrow there is a board exam of computer of class 10th cbse
both ans is wrong
Answers
Answered by
1
Ques.1. Write a SQL query to fetch the count of employees working in project 'P1'.
Ques.2. Write a SQL query to fetch employee names having salary greater than or equal to 5000 and less than or equal 10000.
Ques.3. Write a SQL query to fetch project-wise count of employees sorted by project's count in descending order.
Ques.4. Write a query to fetch only the first name(string before space) from the FullName column of EmployeeDetails table.
Ques.5. Write a query to fetch employee names and salary records. Return employee details even if the salary record is not present for the employee.
Question 7:
Consider the following tables SCHOOL and ADMIN and answer (a) and (b) parts of this question : Questions for Class 12 Computer Science (C++) - Structured Query Language-8
Ques.2. Write a SQL query to fetch employee names having salary greater than or equal to 5000 and less than or equal 10000.
Ques.3. Write a SQL query to fetch project-wise count of employees sorted by project's count in descending order.
Ques.4. Write a query to fetch only the first name(string before space) from the FullName column of EmployeeDetails table.
Ques.5. Write a query to fetch employee names and salary records. Return employee details even if the salary record is not present for the employee.
Question 7:
Consider the following tables SCHOOL and ADMIN and answer (a) and (b) parts of this question : Questions for Class 12 Computer Science (C++) - Structured Query Language-8
and my sql command questions
Answered by
0
SQL query means commads
Similar questions