|
|
-
I do not have Oracle Database to test, but it should work...
|
-
This challenge is about finding second highest salary for each department...
|
-
Nikola Ilijev Commented 2 Years ago through Blogs
`Select cast('' as int)`
`Select floor(rand())`
`Select datediff(mi,'','')`
`Select min(number) from master.dbo.spt_values where type='P'`
`Select count(*) From sys.databases Where 'A'='B'`
`Select count(*)-count(*) From sys.databases -- ...
|
-
Nikola Ilijev Commented 2 Years ago through Blogs
`Select cast('' as int)`
`Select floor(rand())`
`Select datediff(mi,'','')`
`Select min(number) from master.dbo.spt_values where type='P'`
`Select count(*) From sys.databases Where 'A'='B'`
`Select count(*)-count(*) From sys.databases -- ...
|
-
Nikola Ilijev Commented 2 Years ago through Blogs
Easy to find a lot of other ways... ;) those are just the first that crossed my mind
Select cast('' as int)
Select floor(rand())
Select datediff(mi,'','')
Select min(number) from master.dbo.spt_values where type='P'
Select cou...
|
-
Nikola Ilijev Commented 2 Years ago through Blogs
Easy to find a lot of other ways... ;) those are just the first that crossed my mind
Select cast('' as int)
Select floor(rand())
Select datediff(mi,'','')
Select min(number) from master.dbo.spt_values where type='P'
Select cou...
|
-
Nikola Ilijev Commented 2 Years ago through Blogs
Select cast('' as int)
Select floor(rand())
Select datediff(mi,'','')
Select min(number) from master.dbo.spt_values where type='P'
Select count(*) From sys.databases Where 'A'='B'
Select count(*)-count(*) From sys.databases -- c...
|
-
Nikola Ilijev Commented 2 Years ago through Blogs
Select cast('' as int)
Select floor(rand())
Select datediff(mi,'','')
Select min(number) from master.dbo.spt_values where type='P'
Select count(*) From sys.databases Where 'A'='B'
Select count(*)-count(*) From sys.databases -- c...
|
-
Nikola Ilijev Answered 2 Years ago through Quizzes
either
select sum(amount) from Invoice
where orderDate >= DateAdd(day,DateDiff(day,0,GetDate()),0)
or
select sum(amount) from Invoice
where orderDate >= Cast(Cast( GetDate() as date) as datetime)
even next will not pe...
|
|
|