how to get the third quarter of employee details from emp?
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
How do you go back in sql?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
Write a sql query to find the names of employees that begin with ‘a’?
What are the different datatypes available in PL/SQL?
What is the largest value that can be stored in a byte data field?
Explain unique key in sql.
Can a key be both primary and foreign?
what are the advantages and disadvantages of cascading style sheets? : Sql dba
What is sql in oracle?
What is a .db file?
What is numeric function sql?
What is trigger explain it?
How does postgresql compare to oracle/db2/ms sql server/informix?
How to order siblings in oracle hierarchy queries?
What are the advantages of stored procedure?