select rownum from employees;

i want to display 1 to 10 numbers using one select statement.

Question Posted / ameer mujahid

Answer Posted / ameer mujahid

Is This Answer Correct ?

0 Yes

19 No

Please Help Members By Posting Answers For Below Questions

what is rollback? : Sql dba

1024

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

1027

How many scalar data types are supported in pl/sql?

978

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

1017

Can we use delete in merge statement?

1002

What is query syntax?

915

How do you copy a table in sql?

1015

what is the difference between delete and truncate statement in sql? : Sql dba

1130

how to load data files into tables with 'mysqlimport'? : Sql dba

1035

how would you get the current date in mysql? : Sql dba

915

What is procedure explain with example?

896

What are its different types of dbms?

957

What is the least restrictive isolation level? : Transact sql

999

How do you update a sql procedure?

974

Explain the purpose of %type and %rowtype data types?

876