Interested to Buy Any Domain ? << Click Here >> for more details...
how to get the third quarter of employee details from emp?
- 2 Answers
- 8050 Views
- CompuTech, I also Faced
- E-Mail Answers
Answer Posted / 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
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba
What is the difference between inner join and outer join?
What is procedure in pl sql?
What is left inner join in sql?
how would you enter characters as hex numbers? : Sql dba
What is the main reason behind using an index?
How do I audit the sql sent to the server?
What is rename command in sql?
Why do we create stored procedures & functions in pl/sql and how are they different?
What are types of indexes in sql?
What are tables in sql?
What is java sql drivermanager?
What is application trigger?
what is table? : Sql dba
What is database white box testing and black box testing?
