Bissoy.com
Doctors Medicines MCQs Q&A

Consider the following table named 'account' . What is the correct SQL to get all the account information of 'Motijheel' branch. Account ID 10001 10002 10003 Account Holder Md. Humaun Kabir Ruhul Amin Aminul Hossain Account type Savings Savings Business Branch Motijheel Uttara Motijheel

Consider the following table named 'account' . What is the correct SQL to get all the account information of 'Motijheel' branch. Account ID 10001 10002 10003 Account Holder Md. Humaun Kabir Ruhul Amin Aminul Hossain Account type Savings Savings Business Branch Motijheel Uttara Motijheel Correct Answer SELECT * FROM account WHERE Branch = Motijheel

SELECT - SQL Function to Read Data in a Table. * - সকল Column কে Read কর। FROM account - যেই Table থেকে Data নিতে হবে। এক্ষেত্রে account টেবিল থেকে ডাটা নিতে হবে। WHERE - Function to match specific conditions. এক্ষেত্রে যে সকল ক্ষেত্রে Branch এর নাম Motijheel সেই সকল রেকর্ড এর নাম Query এর শেষে Show করবে।

Related Questions

Which of the following statements are correct about Kabir’s compositions ? (a) The most revered collection of Kabir’s verses by the Kabir Panthis is the collection Bijak, contained in the Adi Granth. (b) Kabir’s verses in the Panchvani literature composed by the Dadu-Panthis appear to be a little less authentic than the Punjab tradition. (c) Charlotte Vaudeville argues that the corpus of Kabir in the Adi Granth is ‘free from the Kabir Panthi sectarian element’. (d) David Lorenzen believes that all the three major collections of Kabir contain interpolations of material from other sources. Select the correct answer from the code given below:
Rithika had Rs 8000. She invested some of it in savings scheme P and the rest ofthe money in savings scheme Q. She invested for 3 years in savings scheme P and for2 years in savings scheme Q. savings scheme P offers SI at a rate of 20% pa whilesavings scheme Q compounded annually at the rate of 30% pa. The interest receivedfrom savings scheme P is 930 more than the interest received from savings scheme Q.If Rs 1500 is debited from the invested amount of savings scheme P then find thedifference between the amount invested by Rithika in savings scheme P & savingsscheme Q.
Re-arrange the following sentences into a meaningful paragraph. (A) comes into effect from today. The bank's savings account rate was 3.5 per cent during March 2003 to May 2011 for all savings bank account customers (B) The bank's decision comes two days ahead of RBI's monetary policy meet and is likely to trigger (C) with deposits of above Rs 1 crore, it said in a statement. The two-tier savings bank account interest rate (D) to 3.5 per cent, lowest in six years, a decision that will impact 90 per cent of its customers (E) The country's largest lender however will continue to pay 4 per cent interest on savings bank accounts (F) SBI today cut interest rate on savings bank account deposits up to Rs 1 crore by 0.5 per cent (G) rate war among peers. SBI's savings bank account base is of around Rs 9 lakh crore.
Which of the following is not an agreement in restraint of trade?
1. A sells the goodwill of his business with an agreement not to carry on a similar business within specified local limits, so long as the buyer carries on a similar business.
2. A sells the goodwill of his business with an agreement not to carry on a similar business within India, so long as the buyer carries on a similar business.
3. A sells the goodwill of his business with an agreement not to practice the same trade for 25 years.
4. A sells the goodwill of his business with an agreement not to engage in any business competing or liable to compete in any way with the business for the time being carried on by the buyer.
You are the administrator of a SQL Server 2000 computer. The server contains a database named FinanceData that is used by a client/server application. Each employee has a SQL Server login that the application uses to access the server.Your company hires a new employee named Andrew. You create a SQL Server login named Andrew. You also create a database user named Andrew in the database and grant the database user full permissions in the database.Whenever Andrew runs the client/server application, he receives the following error message: "Invalid object name." Andrew also reports that he cannot access the database by using the application.You need to ensure that Andrew can use the application. Which Transact-SQL statement should you execute?
With respect to Arabian Sea Branch and Bay of Bengal branch of the monsoon entering the Indian landmass, consider the following statements: 1. Arabian Sea Branch is much more powerful than the Bay of Bengal branch. 2. Arabian Sea Branch is divided into three distinct streams while Bay of Bengal branch is divided into two distinct streams. Which of the statements given above is/are correct ?
Prior to joining in the Bangladesh Liberation War of 1971, Birsresto Ruhul Amin was -
Birshrestha Ruhul Amin was a member of the-
Birshrestto Ruhul Amin was- ( বীরশ্রেষ্ঠ রুহুল আমিন ছিলেন একজন-)
S1: Kabir knew that Ramananda got up very Early in the morning and went down on the steps of the 'ghat' to the bathe in the waters of the sacred Ganges.
P: As Ramananda came down the steps before daybreak for his usual bath, he trod on the sleeping man.
Q: Kabir at once jumped up and threw himself at the feet of the preacher.
R: "Ram, Ram" he exclaimed in astonishment.
S: One dark night, Kabir went to the 'ghat' and lay down on one of the river steps.
S6: He said, "You have given me the mantra, 'Ram, Ram,' I have become our disciple".

The Proper sequence should be: