sql Archives - Page 34 of 45

SQL join: selecting the last records in a one-to-many relationship

Suppose I have a table of customers and a table of purchases. Each purchase belongs to one customer. I want to get a ...

May 8, 2022
0 Comments

What is the difference between Views and Materialized Views in Oracle?

What is the difference between Views and Materialized Views in Oracle? 8 Answers 8

May 8, 2022
0 Comments

Is a view faster than a simple query?

Is a select * from myView faster than the query itself to create the view (in order to have the same resultSet): select ...

May 8, 2022
0 Comments

How can I see the raw SQL queries Django is running?

Is there a way to show the SQL that Django is running while performing a query? 21 Answers 21

May 8, 2022
0 Comments

Can a foreign key be NULL and/or duplicate?

Please clarify two things for me: Can a Foreign key be NULL? Can a Foreign key be duplicate? As fair as I know, ...

May 7, 2022
0 Comments

Is there a combination of “LIKE” and “IN” in SQL?

In SQL I (sadly) often have to use “LIKE” conditions due to databases that violate nearly every rule of normalization. I can’t change ...

May 7, 2022
0 Comments

Postgres and Indexes on Foreign Keys and Primary Keys

Does Postgres automatically put indexes on Foreign Keys and Primary Keys? How can I tell? Is there a command that will return all ...

May 7, 2022
0 Comments

Altering a column to be nullable

I want to alter a table column to be nullable. I have used: ALTER TABLE Merchant_Pending_Functions Modify NumberOfLocations NULL This gives an error ...

May 7, 2022
0 Comments

Get day of week in SQL Server 2005/2008

If I have a date 01/01/2009, I want to find out what day it was e.g. Monday, Tuesday, etc… Is there a built-in ...

May 7, 2022
0 Comments