Answer Posted / arjun

select * from tablename where rowid=1
union
( select * from tablename
intersect
select * from tablename where rowid = ( select max(rowid)
from tablename));

What are types of exception?

904

---

what is table? : Sql dba

1041

---

Why do we create views in sql?

1129

---

how to drop an existing view in mysql? : Sql dba

1042

---

Does inner join remove duplicates?

930

---

How can you fetch first 5 characters of the string?

997

---

How do you respond to dementia behavior?

956

---

Is full outer join same as cross join?

952

---

What is a unique key and primary key and foreign key?

955

---

Do prepared statements prevent sql injection?

933

---

what are all the different normalizations? : Sql dba

1015

---

how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc

3990

---

What are operators available in sql?

1024

---

Is primary key clustered or nonclustered?

991

---

Why self join is used in sql?

962

---