Answer / rathi.sql

select * from employees
where rownum<=4

Answer / rathi.sql

select * from employees
where rownum<=4

Answer / b v n kiran kumar

SELECT * FROM EMP
WHERE ROWNUM<=4;

Answer / shilpa

select top 4 * from table for sql server

Answer / testing

you can get the first four rows using this query

select * from emp limit 4

Answer / naina singh

select top 4 * from table

Can we create more than one index on particular column?

1 Answers  

What is the difference between "as" and "is" in an oracle stored procedure?

0 Answers  

How to write numeric literals in oracle?

0 Answers  

What is meant by raw datatype?

0 Answers  

Hi All, Recently I attended a interview for a developer position in an educational university. They asked me the a question, I answered somehow but I was not not satisfied myself. Can anybody reply for it? The question is: A business user comes to you directly with an urgent request:: there is a problem with some students not being able to re-enrol. It appears that ?something has gone wrong with the end-dating of some previous courses they had enrolled in, and this is preventing them from completing their on-line re-enrolments?. Fortunately the user has done some analysis on the situation, and has developed some code to change the end dates. They tell you that they have tested this code in the ?dev? environment, and it works fine. They are asking you to please get this implemented in production as soon as possible. What steps would you take in response to their request ? Thanks

2 Answers  

How oracle handles dead locks?

0 Answers  

Use of an integrity constraint is better to validate data. Explain

0 Answers  

What is a cursor in oracle?

0 Answers  

How to convert character types to numeric types?

0 Answers  

One Table having two rows with one colomn having values Like"Male" and "Female". how to upadte these values Like "Female" and "Male" in single update statement.

6 Answers   Polaris,

Why cursor variables are easier to use than cursors?

0 Answers  

How to get a list of all background sessions in the database?

0 Answers