Lab Sql

My SQL query (in Oracle 11g) returns a column like this: 31132,11100,44232 25464,89453,15686 2156… Read more Oracle Sql : Sort Row With Delimited String

In PostgreSQL, what is the ROW() function used for? Specifically what is the difference between SEL… Read more What Is A Row Constructor Used For?

It seems simple but I struggle with it. The question is how can I lock for example a single row fro… Read more How Can I Lock A Single Row In Oracle Sql

i have the same problem here :SQL select rows with only a certain value in them but the solution th… Read more Sql Select The Only Rows With Only A Certain Values In Them

I needed guidance and help with a question I have never done in SQL SERVER. I have this data: Cust_… Read more Purchased A Movie Earlier Than Gladiator Date Sql Server

I am trying to create a query that pulls all customer info from our database, but because there are… Read more Split Row Results To Column

Is there any way to list out the locked tables and to kill the transactions if we want them to be u… Read more How To Find The Table Names Which Are Locked (specific To Any Transaction)

I have a MySQL table with rows that need to be sorted in a particular order decided by the user. In… Read more Best Way To Change Order Of Rows In Mysql Table?