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 sql does db2 use?

946

Why we use join in sql?

932

Can a view be mutating? If yes, then how?

977

Is merge a dml statement?

941

What is a native sql query?

1002

Can you rollback after commit?

950

What is pivot in sql?

887

What is recursive join in sql?

965

What are the triggers associated with image items?

1013

What is difference between joins and union?

1073

Is left join faster than join?

1000

What is left inner join in sql?

999

What is dynamic query?

932

What is mdf ldf and ndf?

952

What is the process of copying data from table a to table b?

1062