Successful
Success is peace of mind which is a direct result of self-satisfaction in knowing you made the effort to become the best that you are capable of becoming.
Friday, July 26, 2019
Thursday, February 21, 2019
Fresh 10 Shayari in Hindi
मजदूर कभी नींद की गोली नहीं खाते।
पहले भी ये हथेली छोटी थी।
अब भी ये हथेली छोटी है।
कल इससे शकहर गिर जाती थी।
अब इससे दवा गिर जाती है।
अब भी ये हथेली छोटी है।
कल इससे शकहर गिर जाती थी।
अब इससे दवा गिर जाती है।
मौला ये तमन्ना है कि,
जब जान से जाऊ,
जिस शान से आया हूँ उसी शान से जाऊ।
क्या सूखे हुए फूल की किस्मत का भरोसा,
मालूम नहीं कब तेरे गुलधान से जाऊ।
जिंदा मुझे देखेंगी तो माँ चीक उटेंगी,
क्या जखम लिए पीट पे मैधान से जाऊ।
जब जान से जाऊ,
जिस शान से आया हूँ उसी शान से जाऊ।
क्या सूखे हुए फूल की किस्मत का भरोसा,
मालूम नहीं कब तेरे गुलधान से जाऊ।
जिंदा मुझे देखेंगी तो माँ चीक उटेंगी,
क्या जखम लिए पीट पे मैधान से जाऊ।
आँखें आपकी हों या मेरी हों,
बस इतनी सी ख्वाहिश है,
कभी नम न हों।
बस इतनी सी ख्वाहिश है,
कभी नम न हों।
जिसने दी है जिंदगी उसका
साया भी नज़र नहीं आता
यूँ तो भर जाती है झोलियाँ
मगर देने वाला नज़र नही आता..
साया भी नज़र नहीं आता
यूँ तो भर जाती है झोलियाँ
मगर देने वाला नज़र नही आता..
उनकी ‘परवाह’ मत करो,
जिनका ‘विश्वास’ “वक्त” के साथ बदल जाये..
‘परवाह’ सदा ‘उनकी’ करो;
जिनका ‘विश्वास’ आप पर “तब भी” रहे’
जब आप का “वक्त बदल” जाये..।
जिनका ‘विश्वास’ “वक्त” के साथ बदल जाये..
‘परवाह’ सदा ‘उनकी’ करो;
जिनका ‘विश्वास’ आप पर “तब भी” रहे’
जब आप का “वक्त बदल” जाये..।
अक्सर महएंगे महंगे गाड़ी चलाने वाला घर पैदल जाता है।
*गुज़र जाते हैं खूबसूरत लम्हें ,*
*यूं ही मुसाफिरों की तरह .*
*यूं ही मुसाफिरों की तरह .*
*यादें वहीं खडी रह जाती हैं ,*
*रूके रास्तों की तरह .*
*रूके रास्तों की तरह .*
एक *"उम्र"* के बाद *"उस उम्र"* की बातें
*"उम्र भर"* याद आती हैं ,
पर *"वह उम्र"* फिर *"उम्र भर"* नहीं आती...
*"उम्र भर"* याद आती हैं ,
पर *"वह उम्र"* फिर *"उम्र भर"* नहीं आती...
*""सदा मुस्कुराते रहिये""*
Wednesday, February 20, 2019
Know INDIA Questions asked in general knowledge exams
India
Indian flag : 🇮🇳
India is union comprising 29 states and 7 union territories, for a total of 36 entities. The states and union territories are further subdivided .
States : 29
Andhra Pradesh
Arunachal Pradesh
Assam
Bihar
Chhattisgarh
GOA
Gujarat
Haryana
Himachal Pradesh
Jammu Kashmir
Jharkhand
Karnataka
Kerala
Madhya Pradesh
Maharashtra
Manipur
Meghalaya
Mizoram
Nagaland
Odhisha
Punjab
Rajasthan
Sikkim
Tamil Nadu
Tripura
Uttar Pradesh
Uttarakhand
West Bengal
Union Territories: 7
Andaman and Nicobar
Chandigarh
Dadra and Nagar Haveli
Daman and Diu
Delhi
Lakshadweep
Puducherry
India will have 9 union territories after october 30 2019 under The Jammu and Kashmir Reorganisation Act, 2019 is an act of the Parliament of India. It contains provisions to reconstitute the state of Jammu and Kashmir into two union territories, one to be eponymously called Jammu and Kashmir, and the other Ladakh. The act will come into effect on 31 October 2019. A bill for the act was introduced by the Minister of Home Affairs Amit Shah in the Rajya Sabha, on 5 August 2019. The bill was passed in Rajya Sabha the same day and was passed by the Lok Sabha on 6 August 2019. It received the President's assent on 9 August 2019.
Capital of India: New Delhi
National calendar of India : SAKA CALENDAR
National anthem of India : JANA GANA MANA
National song of India : Vande Mataram
National fruit of India : Mango
National river of India : Ganga
National flower of India : Lotus
National tree of India : Indain Banyan
National animal of India : Royal Bengal Tiger
National aquatic animal of India : Ganges river Dolphin
National bird of India : Indian peaful (peacock)
National currency of India : Indian Rupee (INR) Rs
National microbe of India : Lactobacillus delbrueckii subsp. bulgaricus
National reptile of India : King Cobra
National heritage animal of India : Indian Elephant
National vegetable of India : Indian Pumpkin
BEST 10 SHAYARI IN HINDI
मुझे जी खोलकर खर्च करो |
मैं अकेला कमाने के लिए काफ़ी हूँ |
जो जुर्म करते है वो इतने बुरे नही होते ।
लेकिन अदालत सजा न देकर उन्हें बिगाड़ देती है ।
देश मे बहोत तनाव है क्या..?
पता तो करो.. चनाव है क्या ?
दो गज़ सही मैरी मिलकियत तो है,
ए मौत तूने मुझे जमींदार कर दिया।
आग के पास कभी मोम ला कर देखूं..
तू इजाजत दे तो तुझे हाथ लगाकर देखूं
मन का मंदिर बडा़ वीरान नजर आता है,
सोचता हूँ तेरी तस्वीर लगाकर देखूं।
फैसला जो कुछ भी हो मन्ज़ूर होना चाहिए
जंग हो या इश्क़ हों भरपूर होना चाहिएछोड़ कर जिसको गए थे आप कोई और था
अब मैं कोई हूं वापस तो आकर देखिए
Shayari 10 fresh in hindi
1. मिज़ाज में थोड़ी सख्ती लाज़िमी है मेरे हज़ूर, लोग पी जाते समंदर अगर खारा न होता |
2. खोटे सिक्के जो अभी-अभी चले हैं बाजार में, वो देखो कमियाँ निकाल रहे हैं मेरे किरदार में |
3. बेवक़्त, बेवजह, बेहिसाब मुस्कुरा देता हूँ, मेरे आधे दुश्मनो को तो मैं यूँ ही हरा देता हूँ |
4. सुना है की इस समुन्दर को बहोत गुमान आया है, उधर ही ले चलो कश्ती जिधर तूफ़ान आया है |
5. न तो तेरे आने की खुशी और न तेरे जाने का गम, बीत गया वो जमाना जब तेरे दिवाने थे हम |
6. मत पढा करो मेरी शायरी को इतने गौर से जनाब, कभी कुछ याद रह गया तो मुझे भूल नहीं पाओगे |
7. ऐसा कोई शहर नहीं, जहा अपना कहर नहीं, ऐसी कोई गली नहीं जहां अपनी चली नहीं |
8. देख दोस्त माचिस तो सिर्फ यूँ ही बदनाम है, वरना आग तो हमारी स्टाइल से भी लगती है |
9. हुकुमत हमारा ख्वाब है, पर तेरी गुलामी भी लाजवाब है, अगर तुम लड़किया शबाब हो, तो हम लड़के भी नवाब हैं |
How overcome shyness -Easy tip for it
How overcome shyness
Tips To Overcome Shyness :
1. Accept Yourself
2. Become Self Aware - Think People are not looking at you
3. Embrace your strengths know your unique quality.
4. Take care of yourself feel about yourself.
5.Practice talking try to be talkative with friends family strangers.
6. Start focusing on others .
7. Take a deep breath concentrate on your breathing.
8. Relax your muscles when you are anxious.
9. Make eye contact as much as possible the more interested you see.
10. Focus on the present moment .
11. MIMIC others interactions their postures and pose and enjoy .
12. Strat saying yes open the door allow you around the people.
Monday, February 11, 2019
Assignment in practical slips of T.Y.B.Sc. in SQL to use Delete,Insert and Update Command.
Assignment in practical slips of T.Y.B.Sc. in SQL to use Delete,Insert and Update Command.
Assignment :-
Assign. Name:-Use of Delete,Insert and Update Command.
CLASS:-T.Y.B.Sc. (Compute Science)
Assign. Name:-Use of Delete,Insert and Update Command.
CLASS:-T.Y.B.Sc. (Compute Science)
************************************************************
Delete Command:-
This is used to delete the touple.We can not delete values on only particular attribute, we have to delete complete records.
Syntax:-
Delete from table name
[Where condition];
Example:-
Delete all records where account number of depositer is 786
CUST_NAME ACC_NO
----------------------- ---------------------
Samir 770
Mahesh 998
Smita 443
Vikas 112
Sachin 89
Vaibhav 786
Answer:-
SQL>delete from depositer where acc_no='786';
1 row deleted.
SQL>select * from depositer;
CUST_NAME ACC_NO
----------------------- ---------------------
Samir 770
Mahesh 998
Smita 443
Vikas 112
Sachin 89
SQL>delete from borrower
2 where loan_no BETWEEN 3 AND 5;
3 row deleted.
SQL>select * from borrower;
CUST_NAME LOAN_NO
--------------- -----------------
Samir 1
Mahesh 2
Vaibhav 6
Update Command:-
In some situations,we may wish to change a value in touple without changing all value in touple. For this purpose, update statement can be used.
Syntax:-
Update table name
SET column name =expression
[Where condition];
Example:-
Update all the branches with increase of 5% annual interest.
ACC_NO BNAME BALANCE
----------- ---------------- ----------------
770 M G ROAD 10000
998 F C ROAD 5000
443 G P ROAD 2000
112 M G ROAD 15000
89 G P ROAD 20000
786 F C ROAD 4000
Answer:-
SQL>update account
2 SET balance=balance*1.05;
6 row created.
SQL>select * from account;
ACC_NO BNAME BALANCE
----------- --------------- ----------------
770 M G ROAD 10500
998 F C ROAD 5250
443 G P ROAD 2100
112 M G ROAD 15750
89 G P ROAD 21000
786 F C ROAD 4200
6 row selected.
Delete Command:-
This is used to delete the touple.We can not delete values on only particular attribute, we have to delete complete records.
Syntax:-
Delete from table name
[Where condition];
Example:-
Delete all records where account number of depositer is 786
CUST_NAME ACC_NO
----------------------- ---------------------
Samir 770
Mahesh 998
Smita 443
Vikas 112
Sachin 89
Vaibhav 786
Answer:-
SQL>delete from depositer where acc_no='786';
1 row deleted.
SQL>select * from depositer;
CUST_NAME ACC_NO
----------------------- ---------------------
Samir 770
Mahesh 998
Smita 443
Vikas 112
Sachin 89
SQL>delete from borrower
2 where loan_no BETWEEN 3 AND 5;
3 row deleted.
SQL>select * from borrower;
CUST_NAME LOAN_NO
--------------- -----------------
Samir 1
Mahesh 2
Vaibhav 6
Update Command:-
In some situations,we may wish to change a value in touple without changing all value in touple. For this purpose, update statement can be used.
Syntax:-
Update table name
SET column name =expression
[Where condition];
Example:-
Update all the branches with increase of 5% annual interest.
ACC_NO BNAME BALANCE
----------- ---------------- ----------------
770 M G ROAD 10000
998 F C ROAD 5000
443 G P ROAD 2000
112 M G ROAD 15000
89 G P ROAD 20000
786 F C ROAD 4000
Answer:-
SQL>update account
2 SET balance=balance*1.05;
6 row created.
SQL>select * from account;
ACC_NO BNAME BALANCE
----------- --------------- ----------------
770 M G ROAD 10500
998 F C ROAD 5250
443 G P ROAD 2100
112 M G ROAD 15750
89 G P ROAD 21000
786 F C ROAD 4200
6 row selected.
Assignment in SQL for Using trigger
Assignment in SQL for Using trigger
Assignment:-Assign. Name:-Using Trigger
CLASS:-T.Y.B.Sc(Computer)
*************************************************************
Triggers:-
SQL> select * from purchase
PO_NO PO_DATE ITEM_NO QTY
-------- --------- ---------- ---------
11 12-MAY-03 101 100
12 17-JUN-03 102 75
13 21-APR-03 103 150
14 14-JAN-04 104 100
SQL> select * from stock;
ITEM_NO QTY
----------- -----------
101 100
102 75
103 150
104 100
<1>
create or replace trigger ptr1 before insert on purchase for each row
declare
v1 integer;
begin
select count(*) into v1 from stock
where Itrmno=:new.Item_no;
if v1=0 then
insert into stock values(:new.Itemno,:new.qty)
else
update stock set qty=qty+:new.qty
where Itemno=:new.Itemno;
end if;
end;
/
SQL> select * from purchase;
Triggers:-
SQL> select * from purchase
PO_NO PO_DATE ITEM_NO QTY
-------- --------- ---------- ---------
11 12-MAY-03 101 100
12 17-JUN-03 102 75
13 21-APR-03 103 150
14 14-JAN-04 104 100
SQL> select * from stock;
ITEM_NO QTY
----------- -----------
101 100
102 75
103 150
104 100
<1>
create or replace trigger ptr1 before insert on purchase for each row
declare
v1 integer;
begin
select count(*) into v1 from stock
where Itrmno=:new.Item_no;
if v1=0 then
insert into stock values(:new.Itemno,:new.qty)
else
update stock set qty=qty+:new.qty
where Itemno=:new.Itemno;
end if;
end;
/
SQL> select * from purchase;
Assignment in SQL for use of set operator
Assignment:-
Assign. Name:- In SQL Use of SET Operator.
CLASS:-T.Y.B.Sc(Computer)
*************************************************************
Use of SET Operator:
- UNION
- INTERSECT
- IN
- NOT IN
SQL>select * from borrower;
CUST_NAME LOAN_NO
--------------------- -------------
Samir 1
Mahesh 2
Smita 3
Vrushali 4
Devendra 5
Vaibhav 6
UNION:-
SQL> (select cust_name from borrower) UNION
(select cust_name from depositer);
CUST_NAME
-----------------------
Devendra
Mahesh
Samir
Smita
Vaibhav
Vrushali
6 rows selected.
SQL> (Select cust_name from borrower) UNION ALL
(Select cust_name from depositer);
CUST_NAME
---------------------------------
Samir
Mahesh
Smita
Vrushali
Devendra
Vaibhav
Samir
Mahesh
Samita
Vrushali
Devendra
11 row selected.
INTERSECT:-
SQL> (Select cust_name from borrower) INTERSECT
(Select cust_name from depositer);
CUST_NAME
----------------------------
Devendra
Mahesh
Samir
Smita
Vrushali
IN:-
SQL> Select DISTINCT cust_name from borrower WHERE
cust_name IN (Select cust_name from depositer);
CUST_NAME
------------------------
Devendra
Mahesh
Samir
Smita
Vrushali
NOT IN:-
SQL> Select DISTINCT cust_name from borrower WHERE
cust_name NOT IN (Select cust_name from depositer);
CUST_NAME
----------------------
Vaibhav
Use of SET Operator:
- UNION
- INTERSECT
- IN
- NOT IN
SQL>select * from borrower;
CUST_NAME LOAN_NO
--------------------- -------------
Samir 1
Mahesh 2
Smita 3
Vrushali 4
Devendra 5
Vaibhav 6
UNION:-
SQL> (select cust_name from borrower) UNION
(select cust_name from depositer);
CUST_NAME
-----------------------
Devendra
Mahesh
Samir
Smita
Vaibhav
Vrushali
6 rows selected.
SQL> (Select cust_name from borrower) UNION ALL
(Select cust_name from depositer);
CUST_NAME
---------------------------------
Samir
Mahesh
Smita
Vrushali
Devendra
Vaibhav
Samir
Mahesh
Samita
Vrushali
Devendra
11 row selected.
INTERSECT:-
SQL> (Select cust_name from borrower) INTERSECT
(Select cust_name from depositer);
CUST_NAME
----------------------------
Devendra
Mahesh
Samir
Smita
Vrushali
IN:-
SQL> Select DISTINCT cust_name from borrower WHERE
cust_name IN (Select cust_name from depositer);
CUST_NAME
------------------------
Devendra
Mahesh
Samir
Smita
Vrushali
NOT IN:-
SQL> Select DISTINCT cust_name from borrower WHERE
cust_name NOT IN (Select cust_name from depositer);
CUST_NAME
----------------------
Vaibhav
Assignment for SQL Queries Operations TYBSc(computer science)
Assignment :-
Assign. Name:-SQL Queries Operations
CLASS:-T.Y.B.Sc. (Computer)
*************************************************************
SQL Queries on Single Table
SQL Simple Queries:-
-Select Clause
-From Clause
-Where Clause
LOAN_NO BNAME AMMOUNT
-------------- ------------ ----------------
1 M G ROAD 10000
2 J M ROAD 15000
3 F C ROAD 12000
4 G P ROAD 25000
5 M G ROAD 18000
6 J M ROAD 5000
7 G P ROAD 20000
Example1:- Find the distinct name of branches in the loan.
SQL>select distinct Bname from loan;
BNAME
-----------------------
F C ROAD
G P ROAD
J M ROAD
M G ROAD
Example2:-Find the loan number of those 10000<=loan amount<=25000.
SQL>select loan_no from loan where amount>=10000 AND amount<=25000;
LOAN_NO
--------------------------
1
2
3
4
5
7
Example3:- Find the loan number,branch name amount of those loans amount between 10000 and 20000.
SQL> select * from loan where amount BETWEEN 10000 AND 20000;
LOAN_NO BNAME AMOUNT
----------------- -------------- -----------------
1 M G ROAD 10000
2 J M ROAD 15000
3 F C ROAD 12000
5 M G ROAD 18000
7 G P ROAD 20000
Example4:- Find all the attribute in loan where interest on the amount is calculated as 3% of the amount.
SQL> select loan_no,Bname,Amount,Amount*0.03 from loan;
LOAN_NO BNAME AMOUNT AMOUNT*0.03
----------------- -------------- ----------------- ----------------------
1 M G ROAD 10000 300
2 J M ROAD 15000 450
3 F C ROAD 12000 360
4 G P ROAD 25000 750
5 M G ROAD 18000 540
6 J M ROAD 5000 150
7 G P ROAD 20000 600
Example5:- Find all the attribute in loam where branch name equal to J M Road.
SQL>select loan_no,Bname,amount from loan where Banme='J M Road';
LOAN_NO BNAME AMMOUNT
--------------- -------------- ------------------
2 J M ROAD 15000
6 J M ROAD 5000
Example6:- Find all the attribute in loan where adds (using + operator ) 500 in amount.
SQL> select loan_no,Bname,amount,amount+500 from loan;
LOAN_NO BNAME AMOUNT AMOUNT+500
----------------- -------------- ----------------- ----------------------
1 M G ROAD 10000 10500
2 J M ROAD 15000 15500
3 F C ROAD 12000 12500
4 G P ROAD 25000 25500
5 M G ROAD 18000 18500
6 J M ROAD 5000 5500
7 G P ROAD 20000 20500
Subscribe to:
Posts (Atom)
Popular posts
-
Solved practical slips of 12th Computer Science journal Program 1:- Write a function in C++ that exchanges data (passing by refer...
