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 sql exception?

977

---

What is a heap in sql?

1077

---

What are the advantages of normalization?

1079

---

how to drop an existing table in mysql? : Sql dba

1051

---

How does a self join work?

1133

---

What schema means?

893

---

What is sql in java?

1096

---

What is rownum?

987

---

What are the ddl commands?

1015

---

Define commit?

1010

---

Why do we need pl sql?

983

---

how to create a new table by selecting rows from another table in mysql? : Sql dba

1113

---

How much ram can sql express use?

992

---

what is a field in a database ? : Sql dba

1068

---

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

2087

---