Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get last 10 records from the table.
- 12 Answers
- 26377 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 |
Does truncate remove indexes?
What are string functions in sql?
How to get each name only once from an employee table?
define different types of trigger. : Sql dba
what are date and time data types in mysql? : Sql dba
Does sql*plus have a pl/sql engine?
I Defined SP1, Sp2 (sp=StoreProcedures)In Package Specification but I Implemented Sp1, sp2, sp3, sp4, sp5 then What type of Error You will find????
What is an escape character in sql?
what does it mean to have quoted_identifier on? : Sql dba
can sql servers linked to other servers like oracle? : Sql dba
How to return an array from java to pl/sql?
Query for second maximum salary in each in each department
15 Answers DST Global Solutions, TCS,
-
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)
