Note: This is an over simplified version of what I am trying to do. Let's say I have a table called USERS that has FIRSTNAME, LASTNAME. Contents are: JOHN SMI
I'm working on this sql challenge, but I don't know if the way to get the top 1% of soloists calculated by the total number of concerts performed. is correct. P
I am looking for some help. I need to create a dependent dropdown based on the previous input. Everything works in my code, and it sends and receives data from
I have this table of students public void onCreate(SQLiteDatabase db) { String createTableStatement= "CREATE TABLE " + STUDENT_TABLES + " (" + ID_COL + "
Bought X times Name Manufacturer 19 Олівець Faber-Castell, Castell 9000 F FaberCastell 14 Наб&#
I need to know if it is possible to feed the PARTITION clause with the latest partition name of a table, instead of using his value. Normaly we have: SELECT *
after 4 days of tries and researchs over the web I can't make my wishes working. Any help would be appreciated !Performed on MYSQL WORKBENCH I got a DB made of
I have a code as follows. My question is - why do we need IF statement for CURSOR%FOUND ? If no rows are found, that will trigger NO_DATA_FOUND condition and co
I need to improve the performance of my insert in my C# application. I first go out and get data from a view. Then I go through a FOREACH loop to insert into a
Can someone please explain why this trigger would start failing and insert the same record repeatedly? It seems as though there is something wrong with the vari
I have a table that looks like this common_id table1_address table2_address table3_address table4_address 123 null null stack building12 null 157 123road stree
I tried fetching error message from the snp_session table in ODI 12C. I have explicitly inserted erroneous data in order to get an error. But that error is not
Given two time-series tables tbl1(time, b_value) and tbl2(time, u_value). https://www.db-fiddle.com/f/4qkFJZLkZ3BK2tgN4ycCsj/1 Suppose we want to find the last
Hi im stuck with this query, what i want is to get one column "fecha_registro_convertida" with the condition of the case statement but also with the CONVERT sta
I want to get my sales for each day which is located in my orders_summary table. orders_summary table columns: id, date, amount, sku_id products table columns:
I’m having trouble on a query right now to retrieve only the last value saved for each group of results. I explain myself with a table. I have these value
What is wrong with this union? first 'select' and ')' are incorrect create table GL_ALL ( select *from GL1 ) UNION ( select *from GL2 ) UNION ( select
I have problem with my function, I'm getting ORA-21700: object does not exist or is marked for delete error. It's caused by table type parameter in cursor, but
I would like to have an autoincrementing string in my BigQuery table. This seems like a good way of doing it: CREATE TABLE dbo.YourTable ( ID INT IDENTITY(1
I would like to generate a sequence of dates in Redshift. I can easily do it in PostgreSQL using the generate_series() function. This function works in Redshift