python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - sql-scripts

Querying Json array column and other current table column

I have a table that has three columns from which I need to retrieve the data. One of the columns OtherNames contain an array of Json Objects. CREATE TABLE Persons ( NameID int, CurrentName var...
test-img

NoviceDeveloper

sql-server

tsql

sql-scripts

Votes: 0

Answers: 1

Latest Answer

As I mentioned in the comments, use OPENJSON against the column, not a scalar variable which contains the value of just one of your rows, and none of the other row data. SELECT P.NameID, ONs.[N...
test-img

Thom A

SQL Query to fetch the customers registered in the DB without email address(CS can have phonenumber and email in the same field but duplicating)

I need help with writing this query please , in the Database - the customer is registered twice , one row with the email address in the VALUE field and the other row with phone number in the SAME VALU...
test-img

Zoghlami TAHER

sql

postgresql

subquery

union

sql-scripts

Votes: 0

Answers: 2

Latest Answer

I suggest that you use the following query, modified with the exact column and table name. We use string_agg to coalesce all the value fields for the same customer id and only show them if none of the...
test-img

user18098820

Sorting DESC results in "Invalid column name" error

I have a table MOVIE with a column Desc which stands for description. I tried to sort by this column: SELECT * , ROW_NUMBER() OVER (ORDER BY [Desc] ASC) AS RowData FROM (SELECT ...
test-img

henryloke

sql

sql-server

sorting

sql-scripts

Votes: 0

Answers: 2

Latest Answer

Try this: SELECT * , ROW_NUMBER() OVER(ORDER BY [Desc] ASC) AS RowData FROM ( SELECT UID, Title, [Desc] AS [Desc] FROM MOVIE ) As RowTable
test-img

Nayanish Damania

Posts

Questions

Blogs

Jobs