No products in the cart.

  1. Homework Help
  2. CBSE
  3. Class 11
  4. Informatics Practices

Create the following SQL table: TRAVEL …

CBSE, JEE, NEET, CUET

CBSE, JEE, NEET, CUET

Question Bank, Mock Tests, Exam Papers

NCERT Solutions, Sample Papers, Notes, Videos

Install Now
Create the following SQL table: TRAVEL and insert the given rows. [2] No Name Tdate KM NOP YOUR adm no Your Name 2015-11-13 200 32 103 Vedika sahai 2016-04-21 100 45 105 Tarun Ram 2016-03-23 350 42 102 John Fen 2016-02-13 90 40 107 Ahmed Khan 2015-01-10 75 2 104 Raveena 2016-05-28 80 4 Question 2: Write SQL Queries for the following: [3] a) To display No, Name, Tdate from the table Travel in descending order of No. b) To display name of all travellers from the table Travel who are travelling by vehicle with code 103 or 102 c) To display the No and Name of those travellers who travelled between “2015-12-21” and “2016- 04-01

    • Posted by Vijay Bhushan 3 years, 7 months ago

    CBSE > Class 11 > Informatics Practices
    • 0 answers
    ANSWER
    http://mycbseguide.com/examin8/

    Related Questions

    Find the maximum value of given list List=[1,2,3,3,3]

    • Posted by Anshin Anshin 6 months, 1 week ago

    CBSE > Class 11 > Informatics Practices
    • 0 answers
    This content has been hidden. One or more users have flagged this content as inappropriate. Once content is flagged, it is hidden from users and is reviewed by myCBSEguide team against our Community Guidelines. If content is found in violation, the user posting this content will be banned for 30 days from using Homework help section. Suspended users will receive error while adding question or answer. Question comments have also been disabled. Read community guidelines at https://mycbseguide.com/community-guidelines.html

    Few rules to keep homework help section safe, clean and informative.
    • Don't post personal information, mobile numbers and other details.
    • Don't use this platform for chatting, social networking and making friends. This platform is meant only for asking subject specific and study related questions.
    • Be nice and polite and avoid rude and abusive language. Avoid inappropriate language and attention, vulgar terms and anything sexually suggestive. Avoid harassment and bullying.
    • Ask specific question which are clear and concise.

    Remember the goal of this website is to share knowledge and learn from each other. Ask questions and help others by answering questions.

    Posted by Abi S 1 week, 2 days ago

    CBSE > Class 11 > Informatics Practices
    • 0 answers
    To create student table with the student id, class, section, gender, name, dob and marks as attributes where the student id is the primary key?

    • Posted by Anjali Rana 3 months, 4 weeks ago

    CBSE > Class 11 > Informatics Practices
    • 1 answers
    1. Which of the following statement is incorrect? (a) 1 Byte 8 bits (c) 1 MB 1024 KB (b) 1 KB 1024 bytes (d) \overline{GB=} 1024 KB

    • Posted by Harleen Kaur 3 months, 2 weeks ago

    CBSE > Class 11 > Informatics Practices
    • 4 answers
    Define each of the following 1.byte 2.kilobyte 3.megabyte 4.gigabyte 5.terabyte

    • Posted by Anchal Ratna 2 months ago

    CBSE > Class 11 > Informatics Practices
    • 1 answers
    Consider a table Student having two fields-FName varchar(20) and LName char(20). If in a record, value stored in Fname is 'Anuj' and LName is 'Batra', then FName and LName will consume and character space respectively.

    • Posted by Rïyä Kümärï 4 months ago

    CBSE > Class 11 > Informatics Practices
    • 0 answers
    8. To find the third largest/smallest number in a list.

    • Posted by Account Deleted 2 months, 1 week ago

    CBSE > Class 11 > Informatics Practices
    • 1 answers
    To find average and grade for given marks python

    • Posted by Bhawana Nag 5 months, 3 weeks ago

    CBSE > Class 11 > Informatics Practices
    • 0 answers
    What is the security thread involved when we throw away electronic gadgets that are non functional

    • Posted by Samyak Jain 2 weeks, 2 days ago

    CBSE > Class 11 > Informatics Practices
    • 0 answers
    . Consider the temperature (in Celsius) of 7 days of a week as 34, 34, 27, 28, 27, 34, 34. Identify the appropriate statistical technique to be used to calculate the following: a) Find the average temperature. b) Find the temperature Range of that week. c) Find the standard deviation temperature.

    • Posted by Priyanka Yadav 4 months, 4 weeks ago

    CBSE > Class 11 > Informatics Practices
    • 0 answers

    myCBSEguide App

    myCBSEguide

    Trusted by 1 Crore+ Students

    Install Now

    Test Generator

    Test Generator

    Create papers online. It's FREE.

    Try Now

    CUET Mock Tests

    CUET Mock Tests

    75,000+ questions to practice only on myCBSEguide app

    Install Now
    Google Play

    Download myCBSEguide App

    All Courses

    Other Websites

    CBSE Courses

    Resources

    Corporate

    NCERT Solutions

    CBSE Sample Papers

    All Content and Intellectual Property is under Copyright Protection | myCBSEguide.com ©2007-2024