Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get last 10 records from the table.
- 12 Answers
- 27226 Views
- iNautix, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / hussain
select * from emp minus select * from emp where rownum<=
(select count(*)-10 from emp);
| Is This Answer Correct ? | 0 Yes | 3 No |
SELECT CNUM,FNAME, DEPTNO
FROM COMPANY
WHERE CNUM <= 10;
| Is This Answer Correct ? | 3 Yes | 12 No |
What is a ddl command?
How to fetch the rows by dynamicaly passing table name through cursor?
What is dense_rank?
What is the trigger in sql?
How do sql triggers work?
what is the order of pre-defined exceptions.
write an sql query to find names of employee start with 'a'? : Sql dba
How many sql databases can you have on one server?
Why self join is used in sql?
Why is stored procedure faster than query?
Which is faster joins or subqueries?
How to get each name only once from an employee table?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
