This is Worked. like this,
Select *
from Invoice i
where i.paid <= i.total
More Related Contents:
- Is it possible to write single query on two table which are not connected to each other?
- How to join 3 and more tables in SQL?
- SQL multiple column ordering
- Is there a combination of “LIKE” and “IN” in SQL?
- What is the difference between single and double quotes in SQL?
- How do you use script variables in psql?
- Effect of NOLOCK hint in SELECT statements
- What is the simplest SQL Query to find the second largest value?
- Are soft deletes a good idea? [duplicate]
- Difference between natural join and inner join
- SQL Server – stop or break execution of a SQL script
- Using ‘case expression column’ in where clause
- What is the difference between using a cross join and putting a comma between the two tables?
- Bulk DELETE on SQL Server 2008 (Is there anything like Bulk Copy (bcp) for delete data?)
- Why is there no PRODUCT aggregate function in SQL?
- PostgreSQL parameterized Order By / Limit in table function
- How can you handle an IN sub-query with LINQ to SQL?
- Concat field value to string in SQL Server
- Convert a string date into datetime in Oracle
- How to convert from varbinary to char/varchar in mysql
- SQL Server replace, remove all after certain character
- Inserting rows into a table with one IDENTITY column only [duplicate]
- How do I list all tables in a schema in Oracle SQL?
- How to retrieve field names from temporary table (SQL Server 2008)
- Why can’t I use an alias for an aggregate in a having clause?
- how to insert unicode text to SQL Server from query window
- When using GETDATE() in many places, is it better to use a variable?
- How to subtract 30 days from the current date using SQL Server
- Select rows with same id but different value in another column
- PostgreSQL: top n entries per item in same table