How do I get the column name of two tables in a single query ? SELECT column_name FROM INFORMATION_SCHEMA.COLUMNS where table_name = 'table_name'; This works for single table. But if I try SELECT column_name FROM INFORMATION_SCHEMA.COLUMNS where table_name = 'table1'…
I have a forum system where user A refers user B. Then user B refers user C. Only then it should be allowed to view. And I want to list user C under user A as well. Here is the…
I want to perform a fill-down activity in PgSQL DDL: create table brands ( id int, category varchar(20), brand_name varchar(20) ); insert into brands values (1,'chocolates','5-star') ,(2,null,'dairy milk') ,(3,null,'perk') ,(4,null,'eclair') ,(5,'Biscuits','britannia') ,(6,null,'good day') ,(7,null,'boost') ,(8,'shampoo','h&s') ,(9,null,'dove'); Expected output is: category…
I have a given dataframe: id listofnumbers 2 [1, 2, 5, 6, 7] 5 [1, 2, 13, 51, 12] Where one column is just id, and the other one is list of number made like that which i got previously…
Trying to exploit SQL injection for my assignment. Is it possible to execute delete or drop query after order by in select query without using the semicolon in Postgresql? This is my sample query: Select * from table order by…
I have a query where I filter a column based on a where clause, like so: select * from table where col = val What value do I set for val so that there is no filtering in the where…
I am trying to find the substring between the first 'a' char in email column before '@', i have written the below sql-query , but i think i can do it in better way . SELECT email, CASE WHEN LENGTH(SUBSTR(email,…
i have this table that has some data, but i want to get the row where a paticular coluom votecount has the highest value: id votecount 1 0 2 1 3 1 4 13 i tried this sql statement: $selectr…
How to filter the row which contains all vowels in the column value. for example, the table letters contains list of column value. str ---- apple orange education I tried the sql with like command. select str from letters where…
I want to fetch the latest entry to the database I have this data When I run this query select id, parent_id, amount, max(created_at) from table group by parent_id it correctly returns the latest entry but not the rest of…