select rownum from employees;

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

Question Posted / ameer mujahid

18 Answers
47675 Views
HCL, Nyros, Oracle, I also Faced
E-Mail Answers

Answer Posted / ameer mujahid

select rownum from employees;

Is This Answer Correct ?

0 Yes

19 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Why do we use joins in sql?

971

what is innodb? : Sql dba

1106

What are aggregate and scalar functions?

1025

What are tables in sql?

1066

What is lookup table in sql?

1049

what are the different functions in sorting an array? : Sql dba

1024

What is Collation Sensitivity ? What are the various type ?

952

How do I start sql profiler?

997

Explain clause in sql?

1032

What is null in pl/sql?

1071

Does postgresql run on the cloud?

1151

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

1021

Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com

2555

What does t sql mean?

949

how many triggers are allowed in mysql table? : Sql dba

1071