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 a scalar value in sql?

1122

what is 'mysqlcheck'? : Sql dba

1063

what are set operators in sql? : Sql dba

1106

What do you mean by rowid?

1023

How do temporal tables work?

1018

What is triggering circuit?

1105

How to get each name only once from an employee table?

1159

What is a relationship and what are they?

1225

What is break?

1256

what is row? : Sql dba

1275

What are the string functions in sql?

1021

What is structural independence and why is it important?

1074

Show how functions and procedures are called in a pl/sql block.

1182

What are sql constraints?

1226

What is integrity in sql?

1103