Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get last 10 records from the table.
- 12 Answers
- 26690 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 |
How do I count records in sql?
Is id a reserved word in sql?
What is the difference between python and sql?
What is compiled query?
How do I run a sql query?
How do you assign Construct the where clause without concatenating Field,value pairs?
What is difference between nchar and nvarchar?
a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.
What is the use of stored procedures?
What is insert command in sql?
what are the limitations of identity column? : Transact sql
What is a nested table in word?
-
Oracle (3259) - 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)
