Answer Posted / apparao akki

Hi all,

plz find the below executed report on the same.
------------------------------------------------------


SQL> select * from person;

PERSON_ID FIRST_NAME LAST_NAME
TITLE_1 TITLE_2 SOCS
---------- --------------------- -------------------------
---------- ---------- -----------
9 ssss rrrrr
tttt gggg 67778-3
1 THUUTHTUT lofstrom
ba null 4940-343
1 ffsdf fsdfsd
fdsfsd fsdf 5454
1 THUUTHTUT lofstrom
ba null 4940-343
1 THUUTHTUT lofstrom
ba null 4940-343
1 appa akki
s/w btech 3i
2 rao
s/w kmm 3i
4 bunny neel
lkg ukg home

8 rows selected.

SQL> select unique(person_id),last_name from person;

PERSON_ID LAST_NAME
---------- -------------------------
2
1 lofstrom
4 neel
1 fsdfsd
9 rrrrr
1 akki

6 rows selected.

SQL> select distinct(person_id) from person;

PERSON_ID
----------
4
9
2
1

What is the difference between sum and count in sql?

984

---

What is the usage of the distinct keyword?

1214

---

What are the different sql commands?

1065

---

What are the different dml commands in sql?

1166

---

Which normal form is best?

948

---

Is left join inner or outer?

1010

---

What are the different types of constraints?

1168

---

What is Histogram?

1554

---

What is cascade in sql?

958

---

How to Declare Fixed Length String Value In PL SQL

1149

---

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1216

---

What is indexing in sql and its types?

1073

---

What is union, minus and interact commands?

1283

---

Can we connect to postgresql using sql developer?

997

---

Explain mutating table error.

1194

---