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 an index?

915

What are all ddl commands?

1015

Which language is used in sql?

992

what is text? : Sql dba

1010

What is an invalid partition table?

962

Are sql database names case sensitive?

937

Where do we use pl sql?

945

What is synchronized subquery?

1094

Does a primary key have to be a number?

918

What is the difference between left outer join and left join?

945

How do you optimize a query?

941

What is the difference between clustered and non-clustered index in sql?

959

What is substitution variable in pl sql?

981

How do I order columns in sql?

914

how to add a new column to an existing table in mysql? : Sql dba

1003