Answer Posted / guru

Please Use Below Query and Kindly post reply feedback

Odd number of records:

select * from emp where (rowid,1) in (select rowid,
mod(rownum,2) from emp);
Output:-
1
3
5
Even number of records:
select * from emp where (rowid,0) in (select rowid,
mod(rownum,2) from emp)
Output:-
2
4
6

For nth number,
Example we r considering number n=10
select * from emp where (rowid,0) in (select rowid,
mod(rownum,10) from emp)

What is pivot in sql?

901

---

What is the starting oracle error number?

1036

---

What is primary key and foreign key?

946

---

What are the 3 modes of parameter?

1144

---

What will you get by the cursor attribute sql%found?

947

---

Can we use commit inside a trigger?

1071

---

What is the difference between a primary key and a unique key?

1043

---

explain mysql aggregate functions. : Sql dba

969

---

What are hotfixes and patches?

928

---

What is normalization sql?

1036

---

how do you know if your mysql server is alive? : Sql dba

1062

---

Write a unique difference between a function and a stored procedure.

976

---

How do I audit the sql sent to the server?

988

---

What is a memo field?

945

---

How do you bind variables in pl sql?

1073

---