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

How do you write a subquery?

1029

Is sql a backend?

1026

What are different types of triggers?

1112

What is use of package in pl sql?

1015

Explain the insert into statements in sql?

1007

What is left join example?

949

What does 0 mean in sql?

966

Is record in pl sql?

975

What are local and global Indexes and where they are useful.

1444

Explain constraints in sql?

1049

Can we use rowid as primary key?

989

What is sql injection vulnerability?

945

Why query optimization is needed?

930

what is a foreign key ? : Sql dba

1083

How can we implement rollback or commit statement in a trigger?

1039