SQL Server Subquery a

by

You need to use an exists here in your conditional check. Most likely something like this. Without more details it is impossible to know what you are trying to do.

if EXISTS(
select MAX(DonGia) 
from inserted
having MAX(DonGia) >= (select MIN(DonGia) * 1.2 from inserted)
)

More Related Contents:

  1. Max sal to print base on manager_id
  2. Foreign key constraint may cause cycles or multiple cascade paths?
  3. How do I perform an IF…THEN in an SQL SELECT?
  4. Inserting multiple rows in a single SQL query? [duplicate]
  5. Passing a varchar full of comma delimited values to a SQL Server IN function
  6. In SQL, how can you “group by” in ranges?
  7. How to combine date from one field with time from another field – MS SQL Server
  8. How to do a case sensitive search in WHERE clause (I’m using SQL Server)?
  9. SQL Server – stop or break execution of a SQL script
  10. Bulk DELETE on SQL Server 2008 (Is there anything like Bulk Copy (bcp) for delete data?)
  11. Pivot Table and Concatenate Columns
  12. Natural join in SQL Server
  13. Pivot using SQL Server 2000
  14. Transfer data from one database to another database
  15. Sequence vs identity
  16. How to update and order by using ms sql
  17. Using Excel VBA to run SQL query
  18. How to store image in SQL Server database tables column [duplicate]
  19. SQL performance: WHERE vs WHERE(ROW_NUMBER)
  20. The backend version is not supported to design database diagrams or tables
  21. Split string and take last element
  22. Can I set ignore_dup_key on for a primary key?
  23. SQL Server replace, remove all after certain character
  24. How do I add a auto_increment primary key in SQL Server database?
  25. SQL Row_Number() function in Where Clause
  26. When using GETDATE() in many places, is it better to use a variable?
  27. WITH CHECK ADD CONSTRAINT followed by CHECK CONSTRAINT vs. ADD CONSTRAINT
  28. Add a row number to result set of a SQL query
  29. Use one CTE many times
  30. How to Select Every Row Where Column Value is NOT Distinct

Leave a Comment