home
I am working on a query in which I need to find all pair of distinct customers who bought atleast...
I am trying to change the data of status in my sql shown in my gridview but I am unable to do it...
10 minutes ago

Dynamic SQL Command

I want to be able to get only values where there is a '1' in multiple columns. My column names are...
enter image description here enter image description here i have problem with the relation...
I have a following query to insert the data if the shop has only 1 company_id. I dont want to...
This is a database that is a vault. I have three tables: Documents table - actually file names ...
This question already has an answer here: How to calculate age (in...
The Problem: Construct the SQL statement to find all of the messages that Michael Phelps sent....
i search for a solution to convert latitude and longitude in a 2D grid. I have a gamemap with...
I want to find the count of repeated names in a table of name list. it's like names ...
I have a table in MySQL, value tag main_tag ------------------------ 1 tag_A...
Sorry - I hope you don't mind me asking this question but I am new to SQL - Could someone comments...
I store 100s of ad texts in one table, they can either be scheduled or a default one. I want to...
i have two tables which has join I need to return 30% of records per each group rank SELECT ...
I want to show some info about the last 2 registrations in a conference in a table like below. This...
SQL 2012 Based on the stored procedure variable length; Input value is automatically trimmed and...
Why does one of these subquery methods work and the other not work? What would be a more efficient...
In oracle Sql, we need to use '&' indicate substitution variable. If the variable name is...
I am trying to append a key to a nested jsonb in postgres but I get errors. Essentially I start...
I'm doing a registration/login using sql php javascript and html..how do i send de data introduced...
I was able to get the below code to work for what I needed but only when I include the prefix "use"...
I'm trying to find out the most dosed patients in a database. The sum of the doses has to be...
How can I extract the date from a timestamp value variable in Impala? eg time = 2018-04-11...
I am creating a vulnerable Windows Forms application using C# to practise SQL Injection and...
I am creating a query which uses a total of about 20 columns. I have a lot of records that are...
I was wondering if there was another way of giving names to my strings, something like you do in...
Newbie here - I need to get a table output that has one column with say, all the fruit names and...
I am looking for a way to alert / notify my ASP.net application when a record is changed on my...
From Database System Concepts Suppose we have a relation funds_received(dept_name, amount)...