SqlExp C++
PostgreSQL
Select(COLUMN)
.From(TABLE)
select COLUMN
from TABLE
Select(COLUMN.Of(TABLE))
.From(TABLE)
select TABLE.COLUMN
from TABLE
Select(COLUMN.As(A))
.From(TABLE)
select COLUMN as A
from TABLE
Select(TABLE1(COL, A.As("T_A"), SEQ))
.From(TABLE1)
select TABLE1.COL, TABLE1.A as T_A, TABLE1.SEQ
from TABLE1
Select(COLUMN&A)
.From(TABLE)
select COLUMN$A
from TABLE
Select(COLUMN[3])
.From(TABLE)
select COLUMN3
from TABLE
Select(COLUMN1 % COLUMN2)
.From(TABLE)
select mod(COLUMN1, COLUMN2)
from TABLE
Select(COLUMN1 | COLUMN2)
.From(TABLE)
select COLUMN1 || COLUMN2
from TABLE
Select(SqlFunc("any_fn", COLUMN, 2))
.From(TABLE)
select any_fn(COLUMN, 2)
from TABLE
Select(SqlTxt("current_time"))
.From(TABLE1)
select current_time
from TABLE1
Select(Distinct(COLUMN))
.From(TABLE)
select distinct COLUMN
from TABLE
Select(Distinct(SqlSet(COLUMN1, COLUMN2)))
.From(TABLE)
select distinct COLUMN1, COLUMN2
from TABLE
Select(All(COLUMN))
.From(TABLE)
select all COLUMN
from TABLE
Select(Count(COLUMN))
.From(TABLE)
select count(COLUMN)
from TABLE
Select(SqlAll())
.From(TABLE)
select *
from TABLE
SelectAll()
.From(TABLE1)
select *
from TABLE1
Select(SqlCountRows())
.From(TABLE)
select count(*)
from TABLE
Select(COLUMN)
.From(TABLE)
.OrderBy(Descending(COLUMN))
select COLUMN
from TABLE
order by COLUMN desc
Select(SqlMax(COLUMN))
.From(TABLE)
select max(COLUMN)
from TABLE
Select(SqlMin(COLUMN))
.From(TABLE)
select min(COLUMN)
from TABLE
Select(SqlSum(COLUMN))
.From(TABLE)
select sum(COLUMN)
from TABLE
Select(Avg(COLUMN))
.From(TABLE)
select avg(COLUMN)
from TABLE
Select(Abs(COL))
.From(TABLE1)
select abs(COL)
from TABLE1
Select(Stddev(COLUMN))
.From(TABLE)
select stddev(COLUMN)
from TABLE
Select(Variance(COLUMN))
.From(TABLE)
select variance(COLUMN)
from TABLE
Select(Greatest(COLUMN1, COLUMN2))
.From(TABLE)
select greatest(COLUMN1, COLUMN2)
from TABLE
Select(Least(COLUMN1, COLUMN2))
.From(TABLE)
select least(COLUMN1, COLUMN2)
from TABLE
Select(Upper(COLUMN))
.From(TABLE)
select upper(COLUMN)
from TABLE
Select(Lower(COLUMN))
.From(TABLE)
select lower(COLUMN)
from TABLE
Select(Length(COL))
.From(TABLE1)
select length(COL)
from TABLE1
Select(Substr(COL, 2, 1))
.From(TABLE1)
select substr(COL, 2, 1)
from TABLE1
Select(Instr(COLUMN, "hello"))
.From(TABLE)
select INSTR(COLUMN, 'hello')
from TABLE
Select(SqlNvl(COLUMN1, COLUMN2))
.From(TABLE)
select coalesce(COLUMN1, COLUMN2)
from TABLE
Select(NextVal(SEQ)).Get()
select nextval('SEQ')
Select(CurrVal(SEQ)).Get()
select currval('SEQ')
Select(SqlArg())
.From(TABLE)
select ?
from TABLE
Select(Case(COL == 1, "one")
(COL == 2, "two")
("?"))
.From(TABLE1)
select case when COL = 1 then E'one'
when COL = 2 then E'two'
else E'?' end
from TABLE1
Select((COL > 10).AsValue())
.From(TABLE2)
select COL > 10
from TABLE2
Select((COL > 10).As("GT10"))
.From(TABLE2)
select COL > 10 as GT10
from TABLE2
Select(COLUMN)
.From(TABLE)
.Where(COLUMN / 2 > 1 && COLUMN1 == "A" ||
COLUMN2 == Date(2006, 1, 1))
select COLUMN
from TABLE
where COLUMN / 2 > 1 and COLUMN1 = 'A' or COLUMN2 = '2006-01-01'
Select(COLUMN)
.From(TABLE)
.Where(!(COLUMN == 1))
select COLUMN
from TABLE
where not (COLUMN = 1)
Select(COLUMN)
.From(TABLE)
.Where((COLUMN1 == 1) - (COLUMN2 == 1))
select COLUMN
from TABLE
where COLUMN1 = 1 and not COLUMN2 = 1
Select(COLUMN)
.From(TABLE)
.Where(IsNull(COLUMN1))
select COLUMN
from TABLE
where COLUMN1 is NULL
Select(COLUMN)
.From(TABLE)
.Where(NotNull(COLUMN1))
select COLUMN
from TABLE
where COLUMN1 is not NULL
Select(COLUMN)
.From(TABLE)
.Where(Like(COLUMN1, Wild("A*")))
select COLUMN
from TABLE
where COLUMN1 like 'A%%'
Select(COLUMN)
.From(TABLE)
.Where(NotLike(COLUMN1, Wild("A*")))
select COLUMN
from TABLE
where COLUMN1 not like 'A%%'
Select(COLUMN)
.From(TABLE)
.Where(In(COLUMN, Select(COLUMN).From(TABLE1)))
select COLUMN
from TABLE
where COLUMN in (select COLUMN from TABLE1)
Select(COLUMN)
.From(TABLE)
.Where(COLUMN == Select(COLUMN).From(TABLE1))
select COLUMN
from TABLE
where COLUMN in (select COLUMN from TABLE1)
Select(COLUMN)
.From(TABLE)
.Where(NotIn(COLUMN,
Select(COLUMN).From(TABLE1)))
select COLUMN
from TABLE
where COLUMN not in (select COLUMN from TABLE1)
Select(COLUMN)
.From(TABLE)
.Where(COLUMN != Select(COLUMN).From(TABLE1))
select COLUMN
from TABLE
where COLUMN not in (select COLUMN from TABLE1)
Select(COLUMN)
.From(TABLE)
.Where(Exists(Select(COLUMN).From(TABLE1)))
select COLUMN
from TABLE
where exists (select COLUMN from TABLE1)
Select(COLUMN)
.From(TABLE)
.Where(NotExists(Select(COLUMN).From(TABLE1)))
select COLUMN
from TABLE
where not exists (select COLUMN from TABLE1)
Select(COLUMN1)
.From(TABLE1)
| Select(COLUMN2).From(TABLE2)
((select COLUMN1 from TABLE1)
union (select COLUMN2 from TABLE2))
Select(COLUMN1)
.From(TABLE1)
+ Select(COLUMN2).From(TABLE2)
((select COLUMN1 from TABLE1)
union all (select COLUMN2 from TABLE2))
Select(COLUMN1)
.From(TABLE1)
& Select(COLUMN2).From(TABLE2)
((select COLUMN1 from TABLE1)
intersect (select COLUMN2 from TABLE2))
Select(COLUMN1)
.From(TABLE1)
- Select(COLUMN2).From(TABLE2)
((select COLUMN1 from TABLE1)
except (select COLUMN2 from TABLE2))
Select(COLUMN)
.From(TABLE)
.Where(COLUMN == 0)
.GroupBy(COLUMN)
.Having(COLUMN1 == 0)
.OrderBy(Descending(COLUMN))
select COLUMN
from TABLE
where COLUMN = 0
group by COLUMN
having COLUMN1 = 0
order by COLUMN desc
Select(COLUMN)
.From(TABLE).Limit(100)
select COLUMN
from TABLE limit 100
Select(COLUMN)
.From(TABLE).Limit(100, 10)
select COLUMN
from TABLE limit 100, 10
Select(COLUMN)
.From(TABLE).Offset(20)
select COLUMN
from TABLE offset 20
Select(850).Get()
select 850
Select(COLUMN)
.From(TABLE).Hint("hint")
/*+ hint */ select COLUMN
from TABLE
Select(COLUMN)
.From(TABLE)
.InnerJoin(TABLE1)
.On(COLUMN.Of(TABLE) == COLUMN1.Of(TABLE1))
select COLUMN
from TABLE
inner join TABLE1
on TABLE.COLUMN = TABLE1.COLUMN1
Select(COLUMN)
.From(TABLE)
.LeftJoin(TABLE1)
.On(COLUMN.Of(TABLE) == COLUMN1.Of(TABLE1))
select COLUMN
from TABLE
left outer join TABLE1
on TABLE.COLUMN = TABLE1.COLUMN1
Select(COLUMN)
.From(TABLE)
.RightJoin(TABLE1)
.On(COLUMN.Of(TABLE) == COLUMN1.Of(TABLE1))
select COLUMN
from TABLE
right outer join TABLE1
on TABLE.COLUMN = TABLE1.COLUMN1
Select(COLUMN)
.From(TABLE)
.FullJoin(TABLE1)
.On(COLUMN.Of(TABLE) == COLUMN1.Of(TABLE1))
select COLUMN
from TABLE
full outer join TABLE1
on TABLE.COLUMN = TABLE1.COLUMN1
Insert(TABLE)
(COLUMN1, 12)
(COLUMN2, "hello")
(COLUMN, Date(2007, 1, 1))
insert into TABLE(COLUMN1, COLUMN2, COLUMN)
values (12, 'hello', '2007-01-01')
Insert(TABLE)(COLUMN1, 12)(COLUMN2)(COLUMN)
.From(TABLE1)
.Where(COLUMN >= 0)
insert into TABLE(COLUMN1, COLUMN2, COLUMN)
select 12, COLUMN2, COLUMN
from TABLE1
where COLUMN >= 0
Insert(TABLE1)(COLUMN1,"unique")
.Where(NotExists(Select(ID)
.From(TABLE1)
.Where(COLUMN1 == "unique")))
insert into TABLE1(COLUMN1)
select 'unique' where not exists
(select ID
from TABLE1
where COLUMN1 = 'unique')
Insert(TABLE)(COLUMN, Select(COLUMN1)
.From(TABLE1)
.Where(COLUMN2 == 21).AsValue())
insert into TABLE(COLUMN) values ((select
COLUMN1
from TABLE1
where COLUMN2 = 21))
Insert(TABLE1)
(COLUMN1, 12)
(COLUMN2, "hello")
(COL, Date(2007, 1, 1))
.Returning(ID)
insert into TABLE1(COLUMN1, COLUMN2, COL)
values (12, E'hello', date '2007-01-01')
returning ID
ValueMap m;
m(COLUMN1, 1)(COLUMN2, "hello");
Insert(TABLE1)(m)
Update(TABLE2)(m).Where(ID == 123)
insert into TABLE1(COLUMN1, COLUMN2)
values (1, E'hello')
update TABLE2
set COLUMN1 = 1, COLUMN2 = E'hello'
where ID = 123
Update(TABLE)
(COLUMN1, 13)
(COLUMN2, "world")
.Where(COLUMN > Date(2007, 1, 1))
update TABLE
set COLUMN1 = 13, COLUMN2 = 'world'
where COLUMN > '2007-01-01'
Delete(TABLE)
.Where(COLUMN < 0)
delete
from TABLE
where COLUMN < 0
Select(COLUMN)
.From(Select(COLUMN).From(TABLE1))
select COLUMN
from (select COLUMN from TABLE1)
Select(COLUMN)
.From(Select(COLUMN).From(TABLE1)
.AsTable(TABLE2))
select COLUMN
from ((select COLUMN from TABLE1) as TABLE2)
Select(COLUMN)
.From(TABLE)
.LeftJoin(Select(COLUMN).From(TABLE1))
.On(COLUMN.Of(TABLE) == COLUMN1.Of(TABLE1))
select COLUMN
from TABLE left outer join
(select COLUMN from TABLE1)
on TABLE.COLUMN = TABLE1.COLUMN1
Select(COLUMN)
.From(TABLE)
.LeftJoin(Select(COLUMN).From(TABLE1)
.AsTable(TABLE2))
.On(COLUMN.Of(TABLE) == COLUMN1.Of(TABLE1))
select COLUMN
from TABLE
left outer join
((select COLUMN from TABLE1) as TABLE2)
on TABLE.COLUMN = TABLE1.COLUMN1
Select(TABLE(COLUMN, COLUMN1)).From(TABLE)
select TABLE.COLUMN, TABLE.COLUMN1 from TABLE
Select(ID(ID, NAME, LASTNAME))
.From(TABLE1).LeftJoinRef(TABLE2)
.Where(BDATE == Date(2011, 12, 9))
select ID.ID, ID.NAME, ID.LASTNAME
from TABLE1 left outer join TABLE2
on TABLE2.TABLE1_ID = TABLE1.NAME
where BDATE = date '2011-12-09'
Note: Based on .sch file REFERENCES
Select(ID(ID, NAME, LASTNAME))
.From(TABLE1).LeftJoinRef(TABLE2)
.On(IsNull(BDATE))
.Where(BDATE == Date(2011, 12, 9))
select ID.ID, ID.NAME, ID.LASTNAME
from TABLE1 left outer join TABLE2
on TABLE2.TABLE1_ID = TABLE1.NAME
and BDATE is NULL
where BDATE = date '2011-12-09'
Note: Based on .sch file REFERENCES
Select(TABLE1(SqlAll()))
.From(TABLE1)
select TABLE1.* from TABLE1
Select(SqlAll().Of(TABLE1))
.From(TABLE1)
select TABLE1.* from TABLE1
Select(TABLE1(S_TABLE2()))
.From(TABLE1)
select TABLE1.ID, TABLE1.TABLE1_ID, TABLE1.NAME, TABLE1.LASTNAME, TABLE1.BDATE, TABLE1.COLUMN2, TABLE1.SEQ
from TABLE1
Vector<int> m;
m << 1 << 2 << 3;
Select(ID)
.From(TABLE1)
.Where(ID == SqlSetFrom(m))
select ID
from TABLE1
where ID in (1, 2, 3)
WithRecursive(TN)(ID, NAME, PARENT_ID)
.As(Select(ID, NAME, PARENT_ID)
.From(TREENODE)
.Where(IsNull(PARENT_ID))
+
Select(TREENODE(ID, NAME, PARENT_ID))
.From(TREENODE, TN)
.Where(TREENODE(PARENT_ID) == TN(ID)))
.With(TNSIZE)
.As(Select(PARENT_ID,
Select(NAME).From(TREENODE)
.Where(ID == TN(PARENT_ID))
.AsValue(),
SqlCountRows())
.From(TN)
.GroupBy(PARENT_ID)) (SelectAll().From(TNSIZE))
with recursive TN(ID, NAME, PARENT_ID)
as ((select ID, NAME, PARENT_ID
from TREENODE
where PARENT_ID is NULL)
union all
(select TREENODE.ID, TREENODE.NAME,
TREENODE.PARENT_ID
from TREENODE, TN
where TREENODE.PARENT_ID = TN.ID)),
TNSIZE
as (select PARENT_ID,
(select NAME from TREENODE
where ID = TN.PARENT_ID),
count(*)
from TN
group by PARENT_ID)
select * from TNSIZE
Temporary("TT").As(
Select(NAME, LASTNAME).From(TABLE1)
.Where(COLUMN1 == 12))
create temporary table TT as
(select NAME, LASTNAME from TABLE1
where COLUMN1 = 12)
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4