Write a query to get last 10 records from the table.
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 indexes?
Explain the working of primary key?
The in operator may be used if you know the exact value you want to return for at least one of the columns.
what is the difference between inner and outer join? Explain with example. : Sql dba
What port does sql server use?
1 SELECT a.field1, b.field2, c.field3, d.field4 2 FROM atable a, atable b, ctable c, dtable d 3 ? 4 ORDER BY 1 What is the minimum number of joins that must be specified on line 3 in the sample code above to properly link the tables? Notice that the table "atable" is aliased twice: once as "a" and once as "b." 1. One join 2. Two joins 3. Three joins 4. Four joins 5. Five joins
What is oracle pl sql developer?
What are character functions?
Is microsoft sql free?
How do I restart sql?
What is pl sql commands?
Is t sql a programming language?
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)