So I just started learning SQL online and while learning about constraints, below example was given for using DEFAULT constraint: CREATE TABLE persons( ID INT NULL DEFAULT 100, f_name VARCHAR(25), l_name VCARCHAR(25), UNIQUE(ID) ); My question is, if ID is…
If I run this SQL code in my PostgreSQL database, it works fine: select e.type_id, s.copy_destination || '' FROM ebooks.ebooks e, ebooks.static_text s WHERE e.status_id = 1 But when I add the join, everything goes pear-shaped. So if I run:…
I'm working on a CTE (probably not relevant), and I have two possible inner joins, but the second one should only be used if the first one is empty (it could be used anyway, in fact, IT MUST be executed…
I am trying to query a document in my MongoDB Document: { _id: '111', subEntities: [ { subId: '999', dateOfStart: '2098-01-01', dateOfTermination: '2099-12-31' }, { subId: '998', dateOfStart: '2088-01-01', dateOfTermination: '2089-12-31' } ] } My Query: {"$and": [ {"subEntities.dateOfStart": {"$lte":…
I am trying to run a script with ./insert_data.sh; and I get an error saying there is a syntax error at or near the "." Am working in PSQL, thanks Edit #1: My script: #!/bin/bash # Script to insert data…
I don't even know where to start with this one, or if it's even possible to do in PostgreSQL (or if I'll just need to handle it in my code) I have a table of Bills, which specify which day…
I have the following SQL query and the result of the query is shown below. How do i select multiple minimum values based on cnt column? SELECT a.id , COUNT(a.id) cnt from table1 a where a.id in (SELECT id from…
I've got a simple table, primary key and name. The string always starts with a capital letter but could have more capital letters than just the first character. I want to return all the uppercase characters in the name. select…
When I retrieve data using Select date,type,value from table1 It show the values like below. But I want to customize it like below Can anyone give me idea to do this?
I have a transaction table, I want to get the product ID of the record which is ranked 3rd highest for sales. Please note there there can be multiple transactions for an item and one transaction can have multiple qty.…