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 a loop in sql?

936

---

What is sql clause?

992

---

How do I get sql certification?

924

---

What is the max nvarchar size?

897

---

What is partition in sql query?

946

---

How to process query result in pl/sql?

1060

---

what is the difference between group by and order by in sql? : Sql dba

1053

---

How many tables can a sql database have?

925

---

What is the purpose of the sql select top clause?

1019

---

Is mariadb nosql?

989

---

how is myisam table stored? : Sql dba

996

---

What are types of joins?

908

---

What is the use of index in hive?

958

---

How do I run sql profiler?

1007

---

What is the difference between an inner and outer join?

960

---