Consider the given table Faculty and answer the questions that follow:
F_ID F_Name L_Name Hire_date Salary
102 Amit Mishra 12-10-1998 10000
103 Nitin Vyas 24-12-1994 8000
104 Rakshit Soni 18-5-2001 14000
105 Rashmi Malhotra 11-9-2004 11000
106 Sulekha Srivastav 5-6-2006 10000
Write SQL queries for the following commands:
(i) Find the maximum and the minimum salary.
(ii) Display details of those faculty members whose names start with S.
OR
(i) To count number of different id from faculty.
(ii) To display the details of Faculties whose salary is in the range of
8000 to 12000 (both values included).
Answers
Answered by
0
Answer:
Answer is 105 but you check once
Similar questions