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

Why we use joins in sql?

1036

---

Describe sql comments?

1111

---

what is clause? : Sql dba

1117

---

Why is %isopen always false for an implicit cursor?

1151

---

What are the operators used in select statements?

1098

---

What is sql procedures and functions?

1071

---

What are the indexing methods?

1098

---

Can you have more than one key in a database?

990

---

Explain the the update statement in sql?

1103

---

how to use 'mysql' to run sql statements? : Sql dba

1120

---

What is a table in a database?

1094

---

Can variables be used in sql statements?

1073

---

Is sql free?

1025

---

Write a query to display the current date in sql?

1077

---

is mysql query is case sensitive? : Sql dba

1163

---