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

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

table structure:
----------------

col1 col2
----- -----
01-mar-2012 11:12:46 01-mar-2012 11:12:10
01-mar-2012 11:12:46 01-mar-2012 11:11:23

Write a query to display the result as shown below:

col1 col2
----- -----
01-mar-2012 11:12:46 01-mar-2012 11:12:10

Question Posted / sushma s

Answers were Sorted based on User's Feedback



table structure: ---------------- col1 col2 ----- ----- 01..

Answer / prativa mishra

SELECT * FROM TABLE_NAME WHERE ROWNUM=1

Is This Answer Correct ?    1 Yes 0 No

table structure: ---------------- col1 col2 ----- ----- 01..

Answer / hai

select * from table_name where rownum<2;

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

Why function is used in sql?

0 Answers  

Describe types of sql statements?

0 Answers  

How to write a query to show the details of a student from students table whose

0 Answers  

I have 2 table A and B. In A 1 lakh record is present. In b 20 thousand data is present. To get the unique data from table A and B which join we should prefer left inner join or right outer join. Please answer.

4 Answers   GE,

What is a constraint. Types of constraints ?

5 Answers   Accenture, BirlaSoft,

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

0 Answers  

State the advatage and disadvantage of Cursor's?

2 Answers  

what is a cursor? : Sql dba

0 Answers  

What is faster join or subquery?

0 Answers  

Mention what does the hierarchical profiler does?

0 Answers  

What is lexical units in pl sql?

0 Answers  

Write one update command to update seqno field of a table on the basis of row number.

4 Answers   HCL,

For more SQL PLSQL Interview Questions Click Here
Categories