I need a support for sql query

by

Try this. You can directly pass/use @value in the script as well.

DECLARE @Value INT 
SET @Value = 35

SELECT SUM(DISCOUNT) Discount 
FROM
(
    SELECT 
    CASE 
        WHEN upper_range = (SELECT MAX(upper_range) FROM your_table) AND @Value > upper_range THEN DISCOUNT 
        WHEN @Value BETWEEN  lower_range AND upper_range THEN DISCOUNT 
        ELSE 0 
    END
    DISCOUNT 
    FROM your_table
) A

Output for value 35 is-

300

More Related Contents:

  1. SQL query for salary in emp table
  2. SQL Combine two rows into one
  3. SQL Server bulk insert for large data set
  4. SQL NOT IN not working
  5. How do I ignore ampersands in a SQL script running from SQL Plus?
  6. How to do INSERT into a table records extracted from another table
  7. Is there a Max function in SQL Server that takes two values like Math.Max in .NET?
  8. Difference between CTE and SubQuery?
  9. How do I determine the last day of the previous month using PostgreSQL?
  10. How Can I use “Date” Datatype in sql server?
  11. SQL – many-to-many table primary key
  12. Can a Check constraint relate to another table?
  13. Constraint for only one record marked as default
  14. Storing sex (gender) in database
  15. EXISTS vs JOIN and use of EXISTS clause
  16. SQL count(*) performance
  17. Why is a UDF so much slower than a subquery?
  18. How much disk-space is needed to store a NULL value using postgresql DB?
  19. Get everything after and before certain character in SQL Server
  20. Match only entire words with LIKE?
  21. UNIX_TIMESTAMP in SQL Server
  22. How to return a incremental group number per group in SQL
  23. Retrieve column names and types of a stored procedure? [duplicate]
  24. Generate DEFAULT values in a CTE UPSERT using PostgreSQL 9.3
  25. How to check if a column exists before adding it to an existing table in PL/SQL?
  26. How in H2DB get sql dump like in MySql?
  27. SQL Server equivalent to MySQL’s EXPLAIN
  28. How to get the last day of month in postgres?
  29. SQL: Using DATEADD with bigints
  30. Concat all column values in sql

Leave a Comment