Answer / shailesh jori

select * from table_name where rowid=(select min(rowid) from table_name) or rowid=(select max(rowid) from table_name)

Answer / ajit

SELECT MIN(Obs)
FROM <Table_name>
UNION ALL
SELECT MAX(Obs)
from <Table_name>;

Answer / mahendar reddy

select *from t_name where rownum=1
union
(select *from t_name
intersect
select *from t_name where rowid=(select max(rowid)from t-name));

Answer / arjun

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

How to disable a trigger name update_salary?

0 Answers  

---

Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?

4 Answers   KPIT,

---

Write a query to find second highest salary of an employee.

27 Answers  

---

What is sql partition function?

0 Answers  

---

ex: take one schema in that t1,t2,.....tn tables and you don't no the table name also. write a procedure if enter columns name then display the maching columns .otherwise display the unmatch columns.

1 Answers   Zensar,

---

Which language is used in sql?

0 Answers  

---

What is cascade in sql?

0 Answers  

---

What are the basic sql commands?

0 Answers  

---

Explain the advantages and disadvantages of stored procedure?

0 Answers  

---

what is an alias command? : Sql dba

0 Answers  

---

how to give permission to users that users can update/insert/delete on a row of table on timeing 10am to 6pm only?

4 Answers   TCS,

---

Which is better stored procedure or query?

0 Answers  

---