select source_field from (select rownum rn,source_field from source

how to get required data from oracle
source is like this
ram_05_seetha
lax_05_viswa
bamr05frummy
run_01_away
sw_sas_trim

i want my target data like
ram_05_seetha
lax_05_viswa

to get data using %_05_%
but it will give
ram_05_seetha
lax_05_viswa
bamr05frummy

how can i get my target data?

Question Posted / mukesh

1 Answers
4385 Views
Infosys, I also Faced
E-Mail Answers

Answer Posted / mukesh

select source_field from

(select rownum rn,source_field from source_data
) where rn In(1,2)

Is This Answer Correct ?

1 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is oracle sid?

1006

What is a subquery?

1192

What is a initialization parameter file in oracle?

1087

Point out the difference between user tables and data dictionary?

1038

What are the major difference between truncate and delete?

1137

Describe the types of sub query?

1058

How to find the duplicate rows count from employees table in oracle?

1148

How to retrieve values from data fields in record variables?

1173

What is the difference between online and offline backups?

1135

Can we write insert statement in function in oracle?

1156

What to do if dba lost the system password?

1248

How to convert raw data type into text in oracle? Explain

1047

How many anonymous blocks can be defined?

1253

How to define an explicit cursor in oracle?

1102

How to define a data field as not null?

1163