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...

Write a query to get last 10 records from the table.

Answer Posted / pallavi v

with temp as
(select * from emp order by rownum desc)
select * from temp where rownum < = 10

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is blob? : Sql dba

1219


What is replication id?

987


Can a trigger call a stored procedure?

1127


What is the starting oracle error number?

1097


Explain ddl statements in pl/sql?

1051


What is sql select statement?

1085


What are the different dcl commands in sql?

1230


Can we create index on primary key?

1018


What is trigger in pl sql?

1047


Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?

2338


What is sql lookup?

970


When sql appeared?

1148


What is delete command in sql?

1173


What is sqlcommand?

1071


Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

1208