Advertisements
Advertisements
प्रश्न
Write a SQL statement using the DISTINCT keyword.
Advertisements
उत्तर
DISTINCT keyword:
The DISTINCT keyword is used along with the SELECT command to eliminate duplicate rows in the table. This helps to eliminate redundant data. For
Example
SELECT DISTINCT Place FROM Student;
Will display the following data as follows :
SELECT * FROM Student;
Output
Place
Chennai
Bangalore
Delhi
APPEARS IN
संबंधित प्रश्न
The clause used to sort data in a database.
Write a query that selects all students whose age is less than 18 in order wise.
Write the difference between table constraint and column constraint?
Which component of SQL lets inserts values in tables and which lets to create a table?
Write the use of the Savepoint command with an example.
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 the details of all employees in descending order of pay.
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 the details of all employees who are operators.
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.
Write a SQL statement to create a table for employees having any five fields and create a table constraint for the employee table.
