Interested to Buy Any Domain ? << Click Here >> for more details...
how to get the third quarter of employee details from emp?
- 2 Answers
- 8055 Views
- CompuTech, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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
| Is This Answer Correct ? | 4 Yes | 0 No |
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)
| Is This Answer Correct ? | 5 Yes | 4 No |
What does “select count(1) from tab” result?
What is difference between rank () row_number () and dense_rank () in sql?
Does user triggers have entry for trigger with compilation errors?
How many types of privileges are available in sql?
What kind of join is join?
What is a full join sql?
i don't want the message as 14 rows updated just it should update what it will do
real time applications of nullif?
what is a foreign key ? : Sql dba
What is difference sql and mysql?
what is 'trigger' in sql? : Sql dba
how to analyze tables with 'mysqlcheck'? : Sql dba
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
