You can implement a XOR like this – don’t forget that the question will require you to use <= to correctly use the XOR operator:
SELECT name
, population
, area
FROM world
WHERE (area > 3000000 AND population <= 250000000)
OR (area <= 3000000 AND population > 250000000)
Related Posts:
- How to drop a table if it exists?
- SQL Server Installation – What is the Installation Media Folder?
- SQL-Server: The backup set holds a backup of a database other than the existing
- Search all tables, all columns for a specific value SQL Server [duplicate]
- vs shell installation has failed with exit code 1638
- What is the data type for Currency in SQL Server?
- An explicit value for the identity column in table can only be specified when a column list is used and IDENTITY_INSERT is ON SQL Server
- LIKE vs CONTAINS on SQL Server
- What is an MDF file? [closed]
- Selecting COUNT(*) with DISTINCT
- Case in Select Statement
- What is a stored procedure?
- What is the difference between varchar and nvarchar?
- LEFT JOIN vs. LEFT OUTER JOIN in SQL Server
- Inserting multiple rows in a single SQL query? [duplicate]
- What do Clustered and Non-Clustered index actually mean?
- LEFT JOIN vs. LEFT OUTER JOIN in SQL Server
- SQL Server: Difference between PARTITION BY and GROUP BY
- Conversion failed when converting date and/or time from character string while inserting datetime
- Self Join to get employee manager name
- How do I UPDATE from a SELECT in SQL Server?
- Is there a Boolean data type in Microsoft SQL Server like there is in MySQL? [duplicate]
- SQL query to select dates between two dates
- Conversion failed when converting date and/or time from character string while inserting datetime
- When should I use CROSS APPLY over INNER JOIN?
- Insert Data Into Temp Table with Query
- SQL query to get the employee name and their manager name from the same table
- error, string or binary data would be truncated when trying to insert
- How to create Temp table with SELECT * INTO tempTable FROM CTE Query
- NOT IN vs NOT EXISTS
- How can I do an UPDATE statement with JOIN in SQL Server?
- Must declare the scalar variable
- T-SQL split string
- Must declare the scalar variable
- Rename column SQL Server 2008
- INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
- Function to Calculate Median in SQL Server
- Efficiently convert rows to columns in sql server
- The SQL OVER() clause – when and why is it useful?
- Update multiple columns in SQL
- Nested select statement in SQL Server
- INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
- Function to Calculate Median in SQL Server
- How do I escape a single quote in SQL Server?
- SQL Server IF EXISTS THEN 1 ELSE 2
- T-SQL split string based on delimiter
- What is the use of GO in SQL Server Management Studio & Transact SQL?
- SQL Query with SUM with Group By
- SQL Server Management Studio, how to get execution time down to milliseconds
- How to rename a table in SQL Server?
- Drop a temporary table if it exists
- How do I perform an IF…THEN in an SQL SELECT?
- How do I escape a single quote in SQL Server?
- How Stuff and ‘For Xml Path’ work in SQL Server?
- Data source name not found, and no default driver specified
- IDENTITY_INSERT is set to OFF – How to turn it ON?
- SQL update from one Table to another based on a ID match
- An attempt was made to access a socket in a way forbidden by its access permissions
- Conversion of a varchar data type to a datetime data type resulted in an out-of-range value in SQL query
- Each GROUP BY expression must contain at least one column that is not an outer reference
- How to drop all tables from a database with one SQL query?
- SQL Server : Arithmetic overflow error converting expression to data type int
- Update statement to update multiple rows
- Optimistic vs. Pessimistic locking
- How to calculate percentage with a SQL statement
- Column name or number of supplied values does not match table definition
- Inserting data into a temporary table
- Can a foreign key be NULL and/or duplicate?
- Why does NULL = NULL evaluate to false in SQL server
- Cannot Connect to Server – A network-related or instance-specific error
- When to use SELECT … FOR UPDATE?
- Import / Export database with SQL Server Server Management Studio
- CREATE VIEW must be the only statement in the batch
- SQL Server FOR EACH Loop
- Difference between JOIN and INNER JOIN
- The target principal name is incorrect. Cannot generate SSPI context
- Query comparing dates in SQL
- The EXECUTE permission was denied on the object ‘xxxxxxx’, database ‘zzzzzzz’, schema ‘dbo’
- Best way to do nested case statement logic in SQL Server
- What is the meaning of the prefix N in T-SQL statements and when should I use it?
- BCP error “Unable to open BCP host data-file”
- How can I clone an SQL Server database on the same server in SQL Server 2008 Express?
- The multi-part identifier could not be bound
- “CASE” statement within “WHERE” clause in SQL Server 2008
- Get day of week in SQL Server 2005/2008
- How to join two tables by multiple columns in SQL?
- Query error with ambiguous column name in SQL
- What is the difference between Scope_Identity(), Identity(), @@Identity, and Ident_Current()?
- Each GROUP BY expression must contain at least one column that is not an outer reference
- incorrect syntax error CREATE VIEW must be the only statement in the batch
- SQL Server : error converting data type varchar to numeric
- How to drop all tables from a database with one SQL query?
- Attach (open) mdf file database with SQL Server Management Studio
- Sql Server string to date conversion
- How to find sum of multiple columns in a table in SQL Server 2005?
- Check if table exists in SQL Server
- Conversion failed when converting from a character string to uniqueidentifier – Two GUIDs
- Operand type clash: int is incompatible with date + The INSERT statement conflicted with the FOREIGN KEY constraint
- Keeping it simple and how to do multiple CTE in a query
- How can I truncate a datetime in SQL Server?