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

when MSQL8.0 is in market

2142


Why stored procedure is faster than query?

1156


How does sql developer connect to oracle database?

1051


Why is a trigger used?

992


how to present a past time in hours, minutes and seconds? : Sql dba

1071


Can there be more than one function with a similar name in a pl/sql block?

1041


How consistent is the view of the data between and within multiple sessions, transactions or statements ?

2270


What are variables in pl sql?

1234


what is the difference between primary key and unique key? : Sql dba

1086


What is the difference between inner join and outer join?

1040


What is using in sql?

1141


Is sql easier than java?

1069


How can we link a sql database to an existing android app?

1080


What operating systems are supported by oracle sql developer?

1015


What are character functions?

1141