I have the following query:

What I am wanting to do, for each employee, is to get the difference between their clockin, and their next respective clockin in hours, and I am utilizing lag. The problem is, the below select gives me the resulting extract(single employee), and I think the 0/zero row is causing the issue, and also causing a false row(s) when I pull multiple employees(second extract screenshot).

i have a problem, i have an intern query who work data.
I want to format this data in a subquery but i am unable to select when the intern subquery use CASE…END functions.

I’m trying to create an age calculation column from a birthdate, and then create an age-group column based on the age column. I’ve done some searching, but all the results I can find are structured differently enough that I’m not sure I’m even approaching this in the correct way.
The query is this:

so i’m currently working with an oracle query that i want to grab first 10 rows using INNER JOIN on 2 tables, however i keep running into the ORA-00923: FROM keyword not found where expected error. Any ideas how to fix this error?

I am trying to query some data as part of an APEX form and if a value isn’t supplied I basically want to remove the clause for it entirely, or effectively nullify it.

I’m new to learning oracle sql, so I’m sure this has a simple solution that I’m missing, but I’m trying to return the first sequence row from each order, not just limit the whole query results to 1 returned row. The query I’m working with is this:

I have a SQL table like this:

So, I have a list of plate numbers from different countries. If I want to filter Croatian plates, how can I do that? Croatian plate formats are like ZG 000-A, ZG 000-AA, ZG 0000-A or ZG 0000-AA. (Ignore the dashes)

I was coding coding in Oracle, when I encounter an issue Declare and syntax, but I don’t know where is it