home
I need help on a course question for my school. So I am supposed to get two tables Seller &...
23 minutes ago

Get datetime format

How can I get a datetime from this date format: Monday_09_25. I want to remove the DAY and just be...
This question already has an answer here: Can I concatenate multiple...
Could anyone give me some pointers on how I would use Python to search a SQLite database for all...
I've had this problem while trying to show in a textbox, the maxim value of salar columns in...
I have a column name which contains name surname (name space surname) and I would like to search it...
I need some help solving this query for my project. The query I'm working on requires 4...
click here for database model Asked: Show for every department with at least 3 employees, the...
1 hour ago

SQL Dates Selection

I Have a OPL_Dates Table with Start Date and End Dates as Below: dbo.OPL_Dates ID Start_date...
I have tried to solve this for a few hours and I am close but haven't been able to get it to work....
trying to find a statement that will return how many times the repeat has occurred and what that...
long story short, I have a coupon system project. in it I have companys, coupons and customer. all...
I have a table that contains all the columns called user records , I'm using a query that contain...
I'm trying to figure out how to do this query where all the newest entries (episodes) are at the...
I have a shopping cart function on my website and I am able to add items to the shopping cart and I...
I had a timed job interview with some interesting problems I'd like to know how to answer. I took...
I have the below query which on the face seems to be working fine however its giving some strange...
I have a SQL query that selects the users from my users table that have sent a message to or...
I need to find the list of all people who have had a child with more than one person. I am using...
I'm trying to come up with a query that counts rows grouped by year, that I've to get from...
3 hours ago

UNPIVOT Table Columns

I want to get my table data in rows instead of columns. Dynamically read the column names...
Lets say I have a table with four columns: FirstName, LastName, Number (not a primary key) and...
I want to count id_r and then return the maxim value of count using MAX(COUNT(id_r)) but shows...
I have a query that contain more that one alias , I want to use some of these aliases inside...
Following are the results of my sql queries: SELECT DISTINCT(department_id) from employees ORDER...
I'm having this problem with a specific task: SELECT radnik.*, nalog.prioritetNalog FROM...
The following is what I am expecting from my tables. An item can be disjointed into a 'Computer' or...
I have 2 tables. Table1 +----+------+ | Id | Name | +----+------+ | | ...
Let's say I have this query:` SELECT IF(uPer="Yes", "Y", "N") AS Manage, ...
This question already has an answer here: Multiple Id's in In...