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 retrive only second row from table?

Answer Posted / priya

select * from emp where empno < (select max(empno) from
emp) and rownum<2 order by empno desc

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the t string functions available in tsql? : Transact sql

1064


What is embedded sql with example?

1099


What are different clauses used in sql?

1174


What is difference between hql and native sql?

1236


What are the types of views in sql?

1141


Can you rollback after commit?

1052


Show how functions and procedures are called in a pl/sql block.

1186


what is a tablespace? : Sql dba

1102


Explain 3 basic parts of a trigger.

1373


What is the use of sqldataadapter?

1026


What are different functions in sql?

998


mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

1096


What are the differences between implicit and explicit cursors?

1110


What is dml statement?

1001


What are the different types of a subquery?

1103