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 mdb stand for?

1016

What are the most important characteristics of pl/sql?

1169

what is 'mysqlcheck'? : Sql dba

1020

What is a loop in sql?

992

which tcp/ip port does sql server run on? : Sql dba

1032

Can we delete column in sql?

1108

What is lexical units in pl sql?

1156

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

1081

What is a subquery in sql?

1048

What are types of indexes in sql?

1092

What are the operators in sql?

1036

How do I run a pl sql program?

1137

what are date and time functions in mysql? : Sql dba

986

What is the difference between microsoft access and sql?

1036

What is triggering circuit?

1074