Consider the following employee table. Write SQL commands for the question. To display all employees whose allowance is between 5000 and 7000.
Advertisements
प्रश्न
Consider the following employee table. Write SQL commands for the question.
| EMP CODE | NAME | DESIG | PAY | ALLO WANCE |
| S1001 | Hariharan | Supervisor | 29000 | 12000 |
| P1002 | Shaji | Operator | 10000 | 5500 |
| P1003 | Prasad | Operator | 12000 | 6500 |
| C1004 | Manjima | Clerk | 8000 | 4500 |
| M1005 | Ratheesh | Mechanic | 20000 | 7000 |
To display all employees whose allowance is between 5000 and 7000.
एका वाक्यात उत्तर
Advertisements
उत्तर
SELECT FROM Employee WHERE ALLOWANCE BETWEEN 5000 AND 7000;
shaalaa.com
SQL Commands and Their Functions
या प्रश्नात किंवा उत्तरात काही त्रुटी आहे का?
पाठ 12: Structured Query Language (SQL) - Evaluation [पृष्ठ २३१]
APPEARS IN
संबंधित प्रश्न
The command to delete a table is ______
The clause used to sort data in a database.
Differentiate Unique and Primary Key constraint.
Which component of SQL lets inserts values in tables and which lets to create a table?
What is a constraint?
Write any three DDL commands.
Write a SQL statement using the DISTINCT keyword.
Write the different types of constraints and their functions.
What are the components of SQL? Write the commands in each.
Construct the following SQL statement in the student table-
SELECT statement using GROUP BY clause.
