Can you help me plase ? I want a result like the table below with Sqlite . task_name status_code department 1 A START PUR 2 B START ENG 3 C FINISH ENG 4 D NOT
I'm having trouble with an error that says: UDA-SQL-0144 An arithmetic exception was detected.[IBM][CLI Driver][DB2/NT64] SQL20448N "1993" cannot be interprete
Is there any way to check if a string is a number in Impala? like is_numeric is SQL?
We have a date of birth field(type date) and user_id in the table and we want to get count of users group by age based on the date of birth field For e.g. afte
I'm having phone number 1212010089 and want to know from which country I'm getting this number.I do have a table_1 which is having column1 area_codewhere lots o
I'm currently creating an app in Oracle APEX and for some unknown to me reason while trying perform UPDATE/DELETE action by clicking on 'edit' button in the rep
We have a date of birth field(type date) and user_id in the table and we want to get count of users group by age based on the date of birth field For e.g. afte
I have a dynamic sql file in which name of TBCREATOR changes as given in a parameter. I use a simple python script to change the TBCREATOR=<variable here>
I have a query which is order by date , there is the query I have simplified it a bit but basically is : select * from (select start_date, to_char(end_date,
I was interested in MT0's answer on this question using intervals and dates. I was working through trying to find a different way to answer the question and I s
I'm a coding newbie, so this may be sort of a dumb question. I was working on an SQL project to learn the language and I wanted to know if there was a way to do
I have a business requirement to select records based on two fields in one table: code1 and code2. The selection is complex and hard-coded, with no codeable rhy
I'm trying to use INSERT statement to add values to a few columns in a new table depending on the value of a column in another table. I'm writing in SQLite. I w
I have a VARCHAR which will return the value something like this '40/4'. Is there a way to convert this VARCHAR to an INT? I tried casting but it is not working
I am defining the prefix of an address and then trying to remove it from the address. How can I define a variable using an if statement or case statement in the
Imagine this is my query : query = ''' SELECT * FROM table WHERE id = {{myid}}''' params = {'myid':3} j= JinJaSql(param_style='pyformat
I have 2 tables named tblDemo and tblSubDemo; tblDemo havve 2 columns _id and _name. tblSubDemo have 3columns, ID,Name, Demo_ID(it is the primary key of tblDemo
I'm using node-mssql 3.2.0 and I need to INSERT INTO a table and return the id of the inserted record. I can successfully use sql.Transaction() to insert data,
Hello infinitely more knowledgeable stack overflow community. I am trying to accomplish the following: There is this quick form a user fills out and part of tha
I tried to get the row number using ROW_NUMBER() but it shows the following error: can't format message 13:896 -- message file C:\WINDOWS\firebird.msg not