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

Differentiate between % rowtype and type record.

0 Answers  

Is pl sql a scripting language?

0 Answers  

How do you clear the screen in sql?

0 Answers  

How do you modify a trigger?

0 Answers  

What is the difference between a query and a report?

0 Answers  




How do you create an update query?

0 Answers  

What is lookup table in sql?

0 Answers  

How do I copy a table in sql?

0 Answers  

What is coalesce sql?

0 Answers  

if we give update table_name set column_name= default. what will happen?

4 Answers   iFlex,

What is the use of double ampersand (&&) in sql queries? Give an example

0 Answers  

hi..........i m Accenture employee...Accenture is an IT company having itz branches in India at Mumbai, Pune,Delhi, Hyderabad, Chennai and Bangalore....Presently there are openings here for SAP, Testing, Oracle,Java,.NET,MAinframe and Peoplesoft...... I am a software engineer working with Accenture,Mumbai....u can mail me in your resume..i`ll forward it to our HR team...my mail id: pankit.lodaya@accenture.com

8 Answers   Wipro,

For more SQL PLSQL Interview Questions Click Here
Categories