ie. select column from table_name where mod(primary_key

how will u get 1 and 3rd and 5th records in table what is
the query in oracle please help me

Question Posted / millar

Answer Posted / millar

ie.

select column from table_name where mod(primary_key_column,2)=1;

select employee_id from employees where mod(employee_id,2)=1

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

how to load dimension table and fact table. plz tell me the steps.

2084

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2118

Why update strategy and union transformations are active? Explain with examples.

1220

how to create user defined function (udf) in informatica

1288

How to create the source and target database connections in server manager?

1072

Explain the types of transformations?

1051

Define pmcmd command?

1028

Why sorter is an active transformation?

1171

As union transformation gives UNION ALL output, how you will get the UNION output?

1087

What is sorter transformation?

1028

How can you increase the performance in joiner transformation?

1181

Describe an informatica powercenter?

1109

explain abt ur project architecture?

2170

What is domain and gateway node?

1153

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2124