SELECT CNUM,FNAME, DEPTNO FROM COMPANY WHERE CNUM <= 10;

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

Question Posted / v.siva ramudu

Answer Posted / v.siva ramudu

SELECT CNUM,FNAME, DEPTNO
FROM COMPANY
WHERE CNUM <= 10;

Is This Answer Correct ?

3 Yes

12 No

Please Help Members By Posting Answers For Below Questions

What is full join in sql?

972

What is the difference between count 1 and count (*) in a sql query?

965

How many sectors are in a partition?

1061

How do rank () and dense_rank () differ?

1021

Can procedure in package be overloaded?

1063

How do I find duplicates in sql?

915

Is stored procedure faster than query?

949

Can sql function call stored procedure?

989

What is sql key?

966

What is the sql*loader? : aql loader

1039

What are the uses of sysdate and user keywords?

1085

Which function is used to return remainder in a division operator in sql?

1117

How do I start pl sql?

931

What is a mutating table and a constraining table?

1088

What is dml with example?

1064