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: www ghris go ke view my payslip at administration police department, table view for college time table, payslips for administration for administration police, construction of topology table and routing table and routing table using bfs in manet routingppt, project topics of hospital administration quality department, administration police payslip view, kenya administration police payslip administration police,

Forum Jump:


Users browsing this thread: 1 Guest(s)