‘Employee’ table has a column named ‘CITY’ that stores city in which each employee resides. Write SQL query to

Question 37 of 40

Q. ‘Employee’ table has a column named ‘CITY’ that stores city in which each employee resides. Write SQL query to display details of all rows except those rows that have CITY as ‘DELHI’ or ‘MUMBAI’ or ‘CHANDIGARH’.

Puducherry TnboardCBSE Class XII Board 2019Subjective· 1mImportance★★★★★

93% · 37/40 Questions

🔒 Locked · start free trial →

You're viewing a preview — the full solution, concept, methods & PYQ mapping are locked.

Start your 14-day free trial to unlock the full solution →

Concept understanding — SQL Query Concepts

SQL Query Concepts — A First Look

Think of a library. You walk in, and instead of wandering through endless shelves, you go to the librarian and say: "Give me all the books by Tagore published after 1950, sorted by title." The librarian knows exactly where everything is, finds what you asked for, and hands you the list. That's what SQL does — but for data stored in a computer.

SQL stands for Structured Query Language. It is the language we use to talk to databases. A database is just a collection of related information stored in tables — like an Excel workbook with multiple sheets, but far more powerful and organised.

The core idea: tables and queries

A database stores data in tables. Each table has rows (records) and columns (fields). For example, a Students table might have columns like RollNo, Name, City, and Marks. Each row is one student's complete information.

A query is simply a question you ask the database. You write it in SQL, and the database returns an answer — usually a new table made from the data that matches your question.

Note

SQL is not a programming language like Python or Java. You don't tell the computer how to find the data. You only say what data you want. The database figures out the fastest way to get it.

The most common SQL command: SELECT

Almost every query begins with SELECT. It means "show me this data." The basic structure is:

SELECT column1, column2 FROM table_name WHERE condition;

Read it like a sentence: "Select these columns from this table where this condition is true."

If you want all columns, you write SELECT *. The asterisk is a shortcut meaning "everything."

Filtering with WHERE

The WHERE clause is your filter. It keeps only the rows that satisfy a condition. For example, if you want students from Delhi only, you write:

SELECT * FROM Students WHERE City = 'Delhi';

You can combine conditions using AND (both must be true) and OR (at least one must be true). This is exactly like everyday logic: "Show me students from Delhi AND who scored above 80."

Sorting with ORDER BY

Data often comes back in no particular order. To arrange it, use ORDER BY. You can sort ascending (smallest first, which is the default) or descending (largest first) using DESC.

SELECT Name, Marks FROM Students ORDER BY Marks DESC;

This gives you a ranked list — highest marks first.

Why SQL matters for commerce and humanities

You will never calculate a formula in SQL. That is not what it does. What SQL does is organise, filter, and retrieve information — and that is the foundation of every data-driven decision. …

Start your 14-day free trial to unlock the full solution →

To exclude specific city values from the result, you use the NOT IN operator in the WHERE clause. This operator filters out any row whose CITY column matches any value in the given list.

The query selects all columns (SELECT *) from the Employee table.
The condition CITY NOT IN ('DELHI', 'MUMBAI', 'CHANDIGARH') ensures that only rows where the city is none of these three are returned.
Remember that NOT IN compares the column value against each item in the list; if the column value equals any one of them, that row is excluded. …

Start your 14-day free trial to unlock the full solution →

To exclude rows where CITY is DELHI, MUMBAI, or CHANDIGARH, use the NOT IN operator with a list of those city names in the WHERE clause.

When you need to filter out specific values from a column, SQL gives you a clean and readable way to do it. The NOT IN operator is exactly what you need here — it lets you specify a list of values to exclude, and the database returns every row where the column does not match any value in that list.

Think of it this way: you want all employees except those living in three particular cities. Instead of writing multiple AND conditions with != (which would be messy and error-prone), you simply write CITY NOT IN ('DELHI', 'MUMBAI', 'CHANDIGARH'). The database checks each row: if the CITY value is any of those three, the row is skipped; otherwise, it is included.

Note

The NOT IN operator works with any data type — numbers, dates, or text. Just ensure the values in the list match the column's data type exactly (here, text strings in single quotes).

The full query would look like this:

SELECT * FROM Employee
WHERE CITY NOT IN ('DELHI', 'MUMBAI', 'CHANDIGARH');

This returns all columns (*) for every employee whose city is not Delhi, Mumbai, or Chandigarh. If you only need specific columns (like name, salary, or department), replace * with those column names. …

Start your 14-day free trial to unlock the full solution →

←Previous questionQ16 — In CHAR(10) and VARCHAR(10), what does the number 10 indicate ?→Next questionQ18 — Write SQL statement to add a column “COUNTRY” with data type and size …

Q.‘Employee’ table has a column named ‘CITY’ that stores city in which each employee resides. Write SQL query to display details of all rows except those rows that have CITY as ‘DELHI’ or ‘MUMBAI’ or ‘CHANDIGARH’.

🎓Unlock everything free for 14 days

Unlock everything free for 14 days