Tag: sql

Get the last login date for all users in Oracle 11g

We have Oracle 11g so the following query didn’t work. select USERNAME,LAST_LOGIN from dba_users Then I searched and people suggested multiple ways and i got confused. What is the correct way to get …

PostgreSQL LIMIT with OFFSET is not working beyond 100000

database offset pagination postgresql sql

I am using postgres (9.6) docker for my project. After loading large volume of data, for example 234453, I need to cut data in chunks using limit and offset. But I have observed that my query is …

group by date and show the values of X(column) which depends on min time of that date and max time of that date in 1 row

php postgresql sql

I have table like I want to group by date which user has the id of u_id =1 and get first time and value of x and get the last time and value of x in same row it should be like what i’ve tried but i cant get the values of xs. the rows: Answer One method uses conditional

Using a Scalar Function that expects a Table Parameter inside an Apply block

sql sql-server tsql xml

TLDR: I have a scalar function, that expects a table-valued parameter and returns the XML representation of that table. Now I need to use this function in a larger Update statement, where the table-parameter of the function is generated by inner Select statements. Hi, We have an XML type definition, say [dbo]…

How to insert from old table to new table using trigger in pl/sql

oracle plsql sql triggers

There is a column which calls as text (column’s name) inside a table. I want to create different columns from this column. How to insert to another table these columns using trigger. I tried few …

Simple query to join with my booking table without duplicating records for each booking

postgresql sql

I have a customer credit table and a booking table, shown below. I’ve executed the following query which works but it’s too simple. I now need to cross join my original query to the booking table so I can check for where the booking status is completed. My second query is wrong because it SUMs the…

Getting an empty result with ‘AND’ operation and wrong result with ‘OR’ operation in SQL

sql

I have two tables and I want to find out the customer_id and customer_name of all customers who bought product A and B both. In this example only the customers with id 1 and 3 have bought both the product A and B. To find that i wrote this code – When I am doing this I am getting an

check for EMAIL format in ROW and return value inside SELECT query

database json sql sql-server

I have a table called user_data and few columns like LOGIN_NAME The column LOGIN_NAME may contain “emailformat@email.com” or just a “username” I need to know if it is possible for me to run a select query and return emailAddress if row has email type format else return userName if it i…