select empno from (select empno from emp order by empno desc) where rownu

Write a query to get last 10 records from the table.

Question Posted / praveen biradar

Answer Posted / praveen biradar

select empno from (select empno from emp order by empno
desc) where rownum<=10 order by empno

Is This Answer Correct ?

10 Yes

6 No

Please Help Members By Posting Answers For Below Questions

how to create a test table in your mysql server? : Sql dba

690

The in operator may be used if you know the exact value you want to return for at least one of the columns.

734

How do I send sql query results to excel?

775

What is a design view?

706

What is offset and limit in sql?

752

how to enter characters as hex numbers? : Sql dba

755

Can we use insert statement in function?

740

Why do we need pl sql?

727

What are different types of tables in sql?

704

Why do we use partitions in sql?

729

what are properties of a transaction? : Sql dba

768

Is sql port 1433 encrypted?

785

How to revise and re-run the last sql command?

842

how to convert numeric values to character strings? : Sql dba

783

What is acid property in a database?

767