select * from emp minus select * from emp where rownum<= (select count(

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

Question Posted / l meher

Answer Posted / l meher

select * from emp minus select * from emp where rownum<=
(select count(*)-10 from emp);

Is This Answer Correct ?

8 Yes

3 No

Please Help Members By Posting Answers For Below Questions

what are the authentication modes in sql server? How can it be changed? : Sql dba

1508

What is a common use of group by in sql?

1094

Is sql procedural language?

1011

what are the different type of sql's statements ? : Sql dba

975

How to execute a stored procedure?

1153

What is AUTH_ID and AUTH_USER in pl/sql ?

2232

Is sql injection illegal?

1079

Why commit is not used in triggers?

1087

how to use myisamchk to check or repair myisam tables? : Sql dba

1015

What is the difference among union, minus and intersect?

1046

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

1171

Which is faster view or stored procedure?

1008

What is sp_helptext?

1109

what is innodb? : Sql dba

1163

Why is sharding used?

1060