1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

Question Posted / prashanth


Which operator do you use to return all of the rows from one query except rows are returned in a sec..

Answer / Kumar Vivekanand Vivek

{"answers": ["The EXCEPT operator is used to exclude duplicate rows from two queries, ensuring that only rows that appear in the first query but not in the second are returned."]}

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

which database is best to use in oracle and sql server? explain reasons?

5 Answers   TCS,

You want to implement the one-to-one relationship while designing tables. How would you do it?

1 Answers  

If there exist a index on the table, and we then make a view on that table (include the indexed column from base table) than why do we require indexing on view?Doesnt it create an overhead?

2 Answers  

What are the system database in sql server 2008?

1 Answers  

What are the two authentication modes in sql server?

1 Answers  

which is best institute to learn sql server in ameerpet or sr nagar or maithrivanam?please help

3 Answers  

Explain unique key in sql server?

1 Answers  

why would you call update statistics? : Sql server database administration

1 Answers  

What is wrong with sql server client libarary dll, ntwdblib.dll?

1 Answers  

You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

1 Answers  

What are the difference between data length and length in SQL Server-2008?

3 Answers   Scio Healthcare,

Explain log shipping and mention its advantages.

1 Answers  

For more SQL Server Interview Questions Click Here
Categories