sql Archives - Page 3 of 45

Programming, sql

IT Nursery

What is the purpose of Order By 1 in SQL select statement?

I’m reading through some old code at work, and have noticed that there are several views with an order by 1 clause. What ...

June 2, 2022
0 Comments

Programming, sql

IT Nursery

Delete sql rows where IDs do not have a match from another table

I’m trying to delete orphan entries in a mysql table. I have 2 tables like this: Table files: | id | .... ------------ ...

June 1, 2022
0 Comments

Programming, sql

IT Nursery

How to Select Every Row Where Column Value is NOT Distinct

I need to run a select statement that returns all rows where the value of a column is not distinct (e.g. EmailAddress). For ...

June 1, 2022
0 Comments

Programming, sql

IT Nursery

SQL Server loop – how do I loop through a set of records

how do I loop through a set of records from a select? So say for example I have a few records that I ...

June 1, 2022
0 Comments

Programming, sql

IT Nursery

postgresql list and order tables by size

How can I list all the tables of a PostgreSQL database and order them by size? 12 Answers 12

June 1, 2022
0 Comments

Programming, sql

IT Nursery

What is Ad Hoc Query?

I’m reading a book about SQL. In that book there’s the term Ad Hoc Query, which I don’t understand. What exactly is an ...

June 1, 2022
0 Comments

Programming, sql

IT Nursery

GROUP BY with MAX(DATE) [duplicate]

This question already has answers here: Fetch the row which has the Max value for a column (35 answers) Closed 4 years ago. ...

June 1, 2022
0 Comments

Programming, sql

IT Nursery

How to create composite primary key in SQL Server 2008

I want to create tables in SQL Server 2008, but I don’t know how to create composite primary key. How can I achieve ...

June 1, 2022
0 Comments

Programming, sql

IT Nursery

Why can’t I use an alias in a DELETE statement?

In SQL Server Compact Edition in Visual Studio 2010 (maybe SQL Server and SQL in general, I don’t know), this command works: DELETE ...

June 1, 2022
0 Comments

Programming, sql

IT Nursery

Foreign key constraint may cause cycles or multiple cascade paths?

I have a problem when I try to add constraints to my tables. I get the error: Introducing FOREIGN KEY constraint ‘FK74988DB24B3C886’ on ...

June 1, 2022
0 Comments