Sql

Search

QUERY JPQL

select la 
  from lancamento la 
 where (:descricao is null or descricao like %:descricao%) 
   and (:dataDe is null or dataVencimento >= :dataDe) 
   and (:dataAte is null or dataVencimento <= :dataAte)

Comment

PREVIOUS	NEXT

Code Example
Sql :: mysql and
Sql :: multiple like values for single column postgres
Sql :: mysql order specific records at the top
Sql :: postgresql < ALL very slow
Sql :: How to calculate average of average salary of departments?
Sql :: mysql installer no packages found
Sql :: how to count with except in psql
Sql :: mysql reset wp_options
Sql :: CREATE MULTIPLE FK
Sql :: drop unique constraint
Sql :: mysql connect error
Sql :: merge query using linked server
Sql :: sql developer export connections
Sql :: remove an object that is dependent on a column in sql
Sql :: sql insert multiple rows from another table
Sql :: check_username
Sql :: low level operator in dbms
Sql :: linq to sql converter online
Sql :: with_for_update sqlalchemy
Sql :: how to select only id where is not in column mysql
Sql :: #configuration database using PostgreSQL in ubuntu
Sql :: mysql procedure between two tables
Sql :: fill up postgres db
Sql :: mariadb set vertical output format
Sql :: oracle connection
Sql :: utiliser 3 jointures mysql
Sql :: sql create table with references not primary key
Sql :: generate sql trigger through ef migration
Sql :: c# sql transaction multiple connections
Sql :: What is the difference between the LIKE and REGEXP operators in mysql?

Search

SQL

QUERY JPQL

ADD CONTENT