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 the use of set statement in tsql? : Transact sql

537

What is an implicit commit?

561

Why do we need pl sql?

550

What are the operators in sql?

532

Is there a way to automate sql execution from the command-line, batch job or shell script?

557

What is a subquery in sql?

511

Is sql harder than python?

612

What is nvl?

617

What is package in pl sql with an examples?

551

Can we use ddl statements in stored procedure sql server?

520

what are the different tables present in mysql? : Sql dba

506

How do I run sql?

622

What is meant by truncate in sql?

528

What is sql and db2?

537

What is a sql schema used for?

546