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 join types in tsql? : Transact sql

0 Answers  

---

How do you create a db file?

0 Answers  

---

What is a transaction?

5 Answers  

---

What is the difference between alter trigger and drop trigger statements?

0 Answers  

---

How to copy a table in another table with datas?

9 Answers  

---

---

Do foreign keys improve performance?

0 Answers  

---

Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?

0 Answers  

---

what is difference between delete and truncate commands? : Sql dba

0 Answers  

---

What is a native sql query?

0 Answers  

---

If we have n no of columns in a table, can we add new column in that table with not null constraint?

2 Answers  

---

How do you explain an index?

0 Answers  

---

Explain the working of foreign key?

0 Answers  

---