Answer Posted / kkparambath

SELECT DISTINCT Example

The "Persons" table:
P_Id LastName FirstName Address City
1 Hansen Ola Timoteivn10 Sandnes
2 Svendson Tove Borgvn 23 Sandnes
3 Pettersen Kari Storgt 20 Stavanger

Now we want to select only the distinct values from the
column named "City" from the table above.

We use the following SELECT statement:
SELECT DISTINCT City FROM Persons

The result-set will look like this:
City
Sandnes
Stavanger

What is the main difference between sql and pl/sql?

1097

---

Is nosql faster than sql?

1024

---

How do I remove sql developer from windows 10?

1111

---

how to start mysql server? : Sql dba

1200

---

Can a foreign key have a different name?

940

---

How do you pronounce sql?

1014

---

Is clustered index a primary key?

949

---

What is the difference between local variables and global variables?

1125

---

What is the difference between delete, truncate and drop command?

1152

---

Why is there a need for sqlcode and sqlerrm variables?

1049

---

What is difference between pl and sql?

1063

---

Differentiate between sga and pga.

1165

---

What is nvarchar max in sql?

1019

---

What is difference between cursor and trigger?

1079

---

What is difference between sql and excel?

1095

---