Why do we use view in sql?

Question Posted / abhishek mishra

0 Answers
908 Views
I also Faced
E-Mail Answers

No Answer is Posted For this Question
Be the First to Post Answer

More SQL PLSQL Interview Questions

What is trigger in flip flop?

suppose we have values like 1 5 7 in a colum.Now we want numbers like(2 3 4 6) that exists between 1 5 7.How can we do this using sql query??

5 Answers Keane India Ltd,

What is the plv (pl/vision) package offers?

0 Answers

Hi, Can anybody please explain me the flow of the below query. I am not able to understand how this query works. This query is for finding the Nth highest salary.. SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal); If N = 2 then second highest salary will be the o/p. If N = 3 then third highest salary will be the o/p. and so on.. Thanks, Nitin

5 Answers Deloitte, Ness Technologies,

What are the pre requisites?

1 Answers

What is transaction control language (tcl)?

0 Answers

What is denormalization in a database?

0 Answers

What is RAC in oracle?

7 Answers MCN Solutions,

What is a primary key sql?

0 Answers

Mention what is the function that is used to transfer a pl/sql table log to a database table?