Answer / eshwer

select * from emp where TO_CHAR(hiredate,'Q')=3;

'Q' Regrives the all the 4 quarters(1,2,3,4) details on
that we retrive the 3 quarter details

Please check it

Answer / rupesh kumar

select * from emp where rownum<=(select round((count(*)/4)
*3) from emp)
minus
select * from emp where rownum<=(select round((count(*)/4)
*2) from emp)

What is the current version of postgresql?

0 Answers  

---

overloading of stored procedure is possible in oracle?

3 Answers   Nelco,

---

i have a table t1 a math 20 b phy 30 cchemisty 10 a math 40 b phy 23 c che 21 a math15 bphy 33 c che 56 write a quire to find out the max markr of each subject

8 Answers  

---

explain the delete statements in sql

0 Answers  

---

Differentiate between syntax and runtime errors.

0 Answers  

---

What is an ndf file?

0 Answers  

---

What can I use instead of union in sql?

0 Answers  

---

Why do we use procedures?

0 Answers  

---

I want to know last five transactions or records from emp table, from now?

11 Answers   Wells Fargo,

---

Do you know the basic structure of PL/SQL?

3 Answers  

---

Explain the order of sql statement execution?

0 Answers  

---

What is the sql*loader? : aql loader

0 Answers  

---