Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

how to get the third quarter of employee details from emp?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you update sql?

909


What is the difference between delete and truncate statement in sql?

1006


What are the advantages of sql?

1005


Mention what are different methods to trace the pl/sql code?

1096


What are primary key and foreign key and how they work?

925


Is pl sql and postgresql same?

1052


How do I view tables in sql developer?

881


How do I send sql query results to excel?

1003


What is rename in sql?

915


How to create an array in pl/sql?

1008


What does trigger mean in psychology?

912


How does cross join work in sql?

955


What are its different types of dbms?

955


What is a sql schema used for?

1026


What does plv msg allows you to do?

1074