Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Create a view on the Client_master table for administration department.
#1

PROGRAM CODE:

CREATE VIEW vw_clientadmin AS
SELECT name, address1, address2,city, pincode, state
FROM client_master;

CREATE VIEW vw_clientadmina as
SELECT name, address1 add1, address2 add2,city, pincode, state
FROM client_master;

SELECT name, address1, address2,city, pincode, state
FROM vw_clientadmin
where city in ('Bombay', 'Delhi');

OUTPUT:

CREATE VIEW succeeded.
CREATE VIEW succeeded.

NAME ADDRESS1 ADDRESS2 CITY PINCODE STATE
-- -- -- -- -- --
Ivan bayross Bombay 400054 Maharastra
Basu navindgi Bombay 400056 maharastra
Ravi sreedharan Delhi 100001 Delhi
Rukmini Bombay 400050 Maharastra

4 rows selected
Reply

Important Note..!

If you are not satisfied with above reply ,..Please

ASK HERE

So that we will collect data for you and will made reply to the request....OR try below "QUICK REPLY" box to add a reply to this page
Popular Searches: administration police department payslips in kenya, www ghris go ke view my payslip at administration police department, how to create routing table based on topological table and distance using bfs in manet ppt, project topics of hospital administration quality department, table view for college time table, payslips for administration for administration police, administration police payslip view,

Forum Jump:


Users browsing this thread: 1 Guest(s)