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)

how to use 'mysql' to run sql statements? : Sql dba

1053

---

What are its different types of dbms?

1005

---

What is sql exception?

974

---

What can sql server reporting services do?

1109

---

Can I join the same table twice?

1044

---

Is sql difficult?

1158

---

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

1165

---

How many subqueries can be nested in a statement?

984

---

What are different sql data types?

1048

---

what is a view? : Sql dba

1092

---

What happens when a trigger is associated to a view?

914

---

What is a pl/sql block?

1227

---

What is data abstraction in sql?

1031

---

When sql appeared?

1101

---

When to use inner join and left join?

959

---