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 are the syntax and use of the coalesce function?

0 Answers  

---

what is data manipulation language? : Sql dba

0 Answers  

---

Query for second maximum salary in each in each department

15 Answers   DST Global Solutions, TCS,

---

what is 'mysqladmin' in mysql? : Sql dba

0 Answers  

---

i have a table like this. cityno cityname mails 1 BANGALORE 8KM 2 HSR LAYOUT 20KM 3 MEJISTIC 30KM 4 JAYADEVA 55KM 5 ITPL 80KM 6 HEBBAL 115KM I HAVE DATA LIKE THIS I WANT O/P LIKE THIS DISTANCE NO.OFCITY 0-50KM 3 51-100KM 2 101-150KM 4 AND SO ON pls give me answer. i want urgent

6 Answers  

---

---

What are character functions in sql?

0 Answers  

---

how can i create a user defined datatype

3 Answers  

---

while loading data into database how can u skip header and footer records in sql*loader

1 Answers   Oracle,

---

How to use transactions efficiently : transact sql

0 Answers  

---

What are sql procedures?

0 Answers  

---

Explain what is a subquery ?

0 Answers  

---

what are the differences among rownum, rank and dense_rank? : Sql dba

0 Answers  

---