...SELECT column_list FROM table-name [WHERE Clause] [GROUP BY clause] [HAVING clause] [ORDER BY clause]; SELECT name, salary, salary*1.2 AS new_salary FROM employee WHERE new_salary /salary*1.2 > 30000; SELECT first_name, last_name, subject FROM student_details WHERE subject IN/NOT IN ('Maths', 'Science'); Select * from product p where EXISTS (select * from order_items o where o.product_id = p.product_id) ------------------------------------------------- SELECT user.name, course.name ------------------------------------------------- FROM `user` ------------------------------------------------- RIGHT JOIN `course` on user.course = course.id SELECT name, salary FROM employee ORDER BY 1, 2; ELECT name, salary FROM employee ORDER BY name DESC, salary DESC; SELECT COUNT (DISTINCT name) FROM employee; HAVING Group functions (MAX,MIN) cannot be used in WHERE Clause but can be used in HAVING clause. SELECT dept, SUM (salary) FROM employee GROUP BY dept HAVING SUM (salary) > 25000 INSERT INTO TABLE_NAME [ (col1, col2, col3,...colN)] VALUES (value1, value2, value3,...valueN); INSERT INTO employee (id, name, dept, age, salary location) SELECT emp_id, emp_name, dept, age, salary, location FROM temp_employee; Copy data from A to B. Select first then insert If you are inserting data to all the columns, the above insert statement can also be written as, INSERT INTO employee SELECT...
Words: 652 - Pages: 3
...property of a text box? When you compare the Text property of a text box with another value the Text property behaves like a variant. Visual Basic compares one text box to another as strings and compares a text box to a numeric variable or constant with a numeric compare. You can force a numeric comparison on a Text property by using the Val function. 6 . Why would it be useful to include the ToUpper method in a comparison? When comparing strings, the case of the characters is important. An uppercase “Y” does not compare equal to a lowercase “y”. Since the user may type a name or word in either uppercase or lowercase or a combination of the two, we must check all possibilities. The easiest way is to use the string function Ucase or Lcase, which returns the uppercase or lowercase equivalency of a string, respectively. 7. Name the types of items that can be used in a comparison. The conditions to be tested can be formed with numeric variables and constants, string variables and...
Words: 902 - Pages: 4
...This page contains all the built-in VBScript functions. The page is divided into following sections: Date/Time Functions Function | Description | CDate | Converts a valid date and time expression to the variant of subtype Date | Date | Returns the current system date | DateAdd | Returns a date to which a specified time interval has been added | DateDiff | Returns the number of intervals between two dates | DatePart | Returns the specified part of a given date | DateSerial | Returns the date for a specified year, month, and day | DateValue | Returns a date | Day | Returns a number that represents the day of the month (between 1 and 31, inclusive) | FormatDateTime | Returns an expression formatted as a date or time | Hour | Returns a number that represents the hour of the day (between 0 and 23, inclusive) | IsDate | Returns a Boolean value that indicates if the evaluated expression can be converted to a date | Minute | Returns a number that represents the minute of the hour (between 0 and 59, inclusive) | Month | Returns a number that represents the month of the year (between 1 and 12, inclusive) | MonthName | Returns the name of a specified month | Now | Returns the current system date and time | Second | Returns a number that represents the second of the minute (between 0 and 59, inclusive) | Time | Returns the current system time | Timer | Returns the number of seconds since 12:00 AM | TimeSerial | Returns the time for a specific hour...
Words: 1154 - Pages: 5
...Banco Intercontinental Brandi Hobbs Upper Iowa University Banco Intercontinental Case Study Introduction Banco Intercontinental (BANINTER) was the second largest privately held commercial bank in the Dominican Republic before it collapsed in 2003. BANINTER was facing a lot of issues related to inefficiencies in the system. The business leaders realized that these inefficiencies resulted in unnecessary expenses and dissatisfied customers. In order to solve this problem, the bank took some steps in order to improve its process (Fishel & Conger, 2009). This was done by creating some processes that were common in other companies during that time. However, there was a lacking of systematic implementation and the efforts tended to be isolated (Fishel & Conger, 2009). The result was that most people in the bank dismissed that these changes in the process would help the business. The beginning Banco Intercontinental of BANINTER was created by Ramon Baez in 1986. Mr. Baez was a former industry minister and businessman. Mr. Baez oldest son,Ramon Baez Figueroa took over his small bank. His son built this small bank to the second largest private commercial bank. Baez Figueroa bagan buying up controlling intersest or whole companies that touched every person in the Dominican Republics everyday life using the BANINTER Group. Throught the BANINTER Group he manager to control the countries media group, the leading and oldest newspaper , a television...
Words: 1453 - Pages: 6
...CUSTOMER RECORD:- Option Explicit Dim f Private Sub Command1_Click() On Error Resume Next f = InputBox("Input Service ID or Family name", "Find") If f <> "" Then Data1.RecordSource = ("select * from tblebill where ServiceIDNo = '" & f + "' or FamilyName= '" & f + "'") Data1.Refresh End If End Sub Private Sub Command2_Click() On Error Resume Next Data1.RecordSource = ("select * from tblebill order by ServiceIDNo asc") Data1.Refresh End Sub Private Sub Command3_Click() On Error Resume Next Dim a As String a = Data1.Recordset.RecordCount MsgBox ("Total record " + a), vbInformation, "Message" End Sub Private Sub Command4_Click() On Error Resume Next Data1.RecordSource = ("Select * from tblebill where ServiceIDNo <> ' '") Data1.Refresh End Sub Private Sub Command5_Click() On Error Resume Next Data1.RecordSource = ("select * from tblebill order by ServiceIDNo desc") Data1.Refresh End Sub Private Sub Form_Load() Data1.DatabaseName = App.Path + "\dbbilling.mdb" End Sub Private Sub Form_QueryUnload(Cancel As Integer, UnloadMode As Integer) On Error Resume Next If MsgBox("Exit?", vbYesNo + vbQuestion, "Message") = vbNo Then Cancel = True End If End Sub SERVICE APPLICATION:- K Private Sub cmddisabled_Click() On Error Resume Next txtdate.Enabled = False Text1.Enabled = False Text2.Enabled = False Text3.Enabled...
Words: 3691 - Pages: 15
...SQL Tutorial SQL TUTORIAL Simply Easy Learning by tutorialspoint.com tutorialspoint.com i ABOUT THE TUTORIAL SQL Tutorial SQL is a database computer language designed for the retrieval and management of data in relational database. SQL stands for Structured Query Language. This tutorial will give you quick start with SQL. Audience This reference has been prepared for the beginners to help them understand the basic to advanced concepts related to SQL languages. Prerequisites Before you start doing practice with various types of examples given in this reference, I'm making an assumption that you are already aware about what is database, especially RDBMS and what is a computer programming language. Copyright & Disclaimer Notice All the content and graphics on this tutorial are the property of tutorialspoint.com. Any content from tutorialspoint.com or this tutorial may not be redistributed or reproduced in any way, shape, or form without the written permission of tutorialspoint.com. Failure to do so is a violation of copyright laws. This tutorial may contain inaccuracies or errors and tutorialspoint provides no guarantee regarding the accuracy of the site or its contents including this tutorial. If you discover that the tutorialspoint.com site or this tutorial content contains some errors, please contact us at webmaster@tutorialspoint.com TUTORIALS POINT Simply Easy Learning Table of Content SQL Tutorial .................................................................
Words: 39505 - Pages: 159
...SQL Tutorial SQL TUTORIAL Simply Easy Learning by tutorialspoint.com tutorialspoint.com i ABOUT THE TUTORIAL SQL Tutorial SQL is a database computer language designed for the retrieval and management of data in relational database. SQL stands for Structured Query Language. This tutorial will give you quick start with SQL. Audience This reference has been prepared for the beginners to help them understand the basic to advanced concepts related to SQL languages. Prerequisites Before you start doing practice with various types of examples given in this reference, I'm making an assumption that you are already aware about what is database, especially RDBMS and what is a computer programming language. Copyright & Disclaimer Notice All the content and graphics on this tutorial are the property of tutorialspoint.com. Any content from tutorialspoint.com or this tutorial may not be redistributed or reproduced in any way, shape, or form without the written permission of tutorialspoint.com. Failure to do so is a violation of copyright laws. This tutorial may contain inaccuracies or errors and tutorialspoint provides no guarantee regarding the accuracy of the site or its contents including this tutorial. If you discover that the tutorialspoint.com site or this tutorial content contains some errors, please contact us at webmaster@tutorialspoint.com TUTORIALS POINT Simply Easy Learning Table of Content SQL Tutorial ......................................
Words: 38789 - Pages: 156
...How to go to your page This eBook includes two bonus chapters, which are paginated separately from the rest of the book. The pagination of the bonus chapters consists of the identifer “BC” followed by the page number. For example, to go to page 5 of the bonus chapters, type BC5 in the “page #” box at the top of the screen and click “Go.” To go to page 15, type BC15… and so forth. Get More and Do More at Dummies.com ® Start with FREE Cheat Sheets Cheat Sheets include • Checklists • Charts • Common Instructions • And Other Good Stuff! To access the Cheat Sheet created specifically for this book, go to www.dummies.com/cheatsheet/excelvbaprogramming Get Smart at Dummies.com Dummies.com makes your life easier with 1,000s of answers on everything from removing wallpaper to using the latest version of Windows. Check out our • Videos • Illustrated Articles • Step-by-Step Instructions Plus, each month you can win valuable prizes by entering our Dummies.com sweepstakes. * Want a weekly dose of Dummies? Sign up for Newsletters on • Digital Photography • Microsoft Windows & Office • Personal Finance & Investing • Health & Wellness • Computing, iPods & Cell Phones • eBay • Internet • Food, Home & Garden Find out “HOW” at Dummies.com *Sweepstakes not currently available in all countries; visit Dummies.com for official rules. Excel VBA Programming ® FOR DUMmIES 2ND ‰ EDITION by John Walkenbach Excel® VBA Programming For Dummies®, 2nd Edition Published...
Words: 98776 - Pages: 396
...A GUIDE TO SQL Eighth Edition This page intentionally left blank A G U I D E TO S Q L Eighth Edition Philip J. Pratt Grand Valley State University Mary Z. Last University of Mary Hardin-Baylor Australia • Brazil • Japan • Korea • Mexico • Singapore • Spain • United Kingdom • United States A Guide to SQL, Eighth Edition Philip J. Pratt, Mary Z. Last Vice President, Publisher: Jack Calhoun Editor-in-Chief: Alex von Rosenberg Senior Acquisitions Editor: Charles McCormick, Jr. Product Manager: Kate Hennessy Development Editor: Jessica Evans Editorial Assistant: Bryn Lathrop Marketing Director: Brian Joyner Marketing Manager: Bryant Chrzan Marketing Communications Manager: Libby Shipp Marketing Coordinator: Suellen Ruttkay Content Project Manager: Matt Hutchinson Art Director: Stacy Jenkins Shirley, Marissa Falco Cover Designer: Joseph Sherman Cover Image: Getty Images/Taxi/Chris Bell Manufacturing Coordinator: Denise Powers © 2009 Course Technology, Cengage Learning ALL RIGHTS RESERVED. No part of this work covered by the copyright hereon may be reproduced, transmitted, stored, or used in any form or by any means graphic, electronic, or mechanical, including but not limited to photocopying, recording, scanning, digitizing, taping, Web distribution, information networks, or information storage and retrieval systems, except as permitted under Section 107 or 108 of the 1976 United States Copyright Act, without the prior written permission of the publisher....
Words: 48772 - Pages: 196
...Microsoft-Access Tutorial Soren Lauesen E-mail: slauesen@itu.dk Version 2.4b: July 2011 Contents 1. The hotel system................................................... 4 2. Creating a database ............................................. 6 2.1 Create a database in Access ............................. 6 2.2 Create more tables ......................................... 10 2.3 Create relationships ....................................... 12 2.4 Look-up fields, enumeration type .................. 14 2.5 Dealing with trees and networks.................... 16 3. Access-based user interfaces ............................. 18 3.1 Forms and simple controls............................. 18 3.1.1 Text box, label and command button...... 18 3.1.2 Adjusting the controls............................. 20 3.1.3 Cleaning up the form .............................. 20 3.1.4 Shortcut keys for the user ....................... 22 3.1.5 Lines, checkbox, calendar....................... 22 3.1.6 Combo box - enumeration type .............. 24 3.1.7 Combo box - table look up ..................... 26 3.1.8 Control properties - text box................... 28 3.2 Subforms........................................................ 30 3.2.1 Subform in Datasheet view..................... 31 3.2.2 Adjust the subform ................................. 34 3.2.3 Mockup subform..................................... 36 3.2.4 Subform in Form view............................ 36 3.2.5 Summary of subforms...................
Words: 54671 - Pages: 219
...A Practical Guide to Linux Commands, Editors, and Shell Programming SECOND EDITION ® Mark G. Sobell Upper Saddle River, NJ • Boston • Indianapolis • San Francisco New York • Toronto • Montreal • London • Munich • Paris • Madrid Capetown • Sydney • Tokyo • Singapore • Mexico City Many of the designations used by manufacturers and sellers to distinguish their products are claimed as trademarks. Where those designations appear in this book, and the publisher was aware of a trademark claim, the designations have been printed with initial capital letters or in all capitals. The author and publisher have taken care in the preparation of this book, but make no expressed or implied warranty of any kind and assume no responsibility for errors or omissions. No liability is assumed for incidental or consequential damages in connection with or arising out of the use of the information or programs contained herein. The publisher offers excellent discounts on this book when ordered in quantity for bulk purchases or special sales, which may include electronic versions and/or custom covers and content particular to your business, training goals, marketing focus, and branding interests. For more information, please contact: U.S. Corporate and Government Sales (800) 382-3419 corpsales@pearsontechgroup.com For sales outside the United States, please contact: International Sales international@pearson.com Visit us on the Web: informit.com/ph Library of Congress Cataloging-in-Publication...
Words: 228961 - Pages: 916
...Microsoft® Office Access 2007 ™ ALL-IN-ONE DESK REFERENCE FOR DUMmIES ‰ by Alan Simpson, Margaret Levine Young, Alison Barrows, April Wells, Jim McCarter Microsoft® Office Access 2007 ™ ALL-IN-ONE DESK REFERENCE FOR DUMmIES ‰ Microsoft® Office Access 2007 ™ ALL-IN-ONE DESK REFERENCE FOR DUMmIES ‰ by Alan Simpson, Margaret Levine Young, Alison Barrows, April Wells, Jim McCarter Microsoft® Office Access™ 2007 All-in-One Desk Reference For Dummies® Published by Wiley Publishing, Inc. 111 River Street Hoboken, NJ 07030-5774 www.wiley.com Copyright © 2007 by Wiley Publishing, Inc., Indianapolis, Indiana Published by Wiley Publishing, Inc., Indianapolis, Indiana Published simultaneously in Canada No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, (978) 750-8400, fax (978) 646-8600. Requests to the Publisher for permission should be addressed to the Legal Department, Wiley Publishing, Inc., 10475 Crosspoint Blvd., Indianapolis, IN 46256, (317) 572-3447, fax (317) 572-4355, or online at http://www...
Words: 190131 - Pages: 761
