Recent Questions/Answers
Category Forums Posted By Replies Posts
IT sector How to search second maximum(second highest) salary value(integer)from table employee (field salary)in the manner so that mysql gets less load? Jennifer 0 reply
IT sector How to Create Table show Example? Jennifer 0 reply
IT sector Restore database (or database table) from backup. Jennifer 0 reply
IT sector How to dump a table from a database? Jennifer 0 reply
IT sector How to dump one database for backup? Jennifer 0 reply
IT sector  How to dump all databases for backup. Backup file is sql commands to recreate all db's? Jennifer 0 reply
IT sector How to Load a CSV file into a table ? Jennifer 0 reply
IT sector How to make a column bigger and Delete unique from table? Jennifer 0 reply
IT sector Change column name and Make a unique column so we get no dupes. Jennifer 0 reply
IT sector How to Delete a column and Add a new column to database ? Jennifer 0 reply
IT sector How to Update database permissions/privilages. Jennifer 0 reply
IT sector How To update info already in a table and Delete a row(s) from a table. Jennifer 0 reply
IT sector How to give user privilages for a db. Login as root. Switch to the MySQL db. Grant privs. Update privs. Jennifer 0 reply
IT sector How to allow the user "sonia" to connect to the server from localhost using the password "passwd". Login as root. Switch to the MySQL db. Give privs. Update privs. Jennifer 0 reply
IT sector How to Update a root password? Jennifer 0 reply
IT sector How to Set a root password if there is on root password? Jennifer 0 reply
IT sector How to Recover a MySQL root password. Stop the MySQL server process. Start again with no grant tables. Login to MySQL as root. Set new password. Exit MySQL and restart MySQL server. Jennifer 0 reply
IT sector How to Change a users password from MySQL prompt. Login as root. Set the password. Update privs. Jennifer 0 reply
IT sector How to Change a users password from unix shell? Jennifer 0 reply
IT sector How to Creating a new user. Login as root. Switch to the MySQL db. Make the user. Update privs. Jennifer 0 reply
IT sector How to Join tables on common columns? Jennifer 0 reply
IT sector How to Return total number of rows? Jennifer 0 reply
IT sector How we will Show selected records sorted in an ascending (asc) or descending (desc)  ? Jennifer 0 reply
IT sector How you will Show unique records in mysql?  Jennifer 0 reply
IT sector Use a regular expression to find records. Use "REGEXP BINARY" to force case-sensitivity. This finds any record beginning with r.  Jennifer 0 reply
IT sector How to show all records starting with the letters 'sonia' AND the phone number '9876543210' limit to records 1 through 5?   Jennifer 0 reply
IT sector How to Show all records starting with the letters 'sonia' AND the phone number '9876543210' ? Jennifer 0 reply
IT sector How you will Show all records not containing the name "sonia" AND the phone number '9876543210' order by the phone_number field?  Jennifer 0 reply
IT sector How will Show all records containing the name "sonia" AND the phone number '9876543210'?  Jennifer 0 reply
IT sector How to Show certain selected rows with the value "pcds" ?  Jennifer 0 reply
IT sector How to returns the columns and column information pertaining to the designated table? Jennifer 0 reply
IT sector How you will Show all data from a table? Jennifer 0 reply
IT sector How to delete a table?     Jennifer 0 reply
IT sector How we get Sum of column? Jennifer 0 reply
IT sector How to delete a database from mysql server? Jennifer 0 reply
IT sector How to see table's field formats or description of table ? Jennifer 0 reply
IT sector How To see all the tables from a database of mysql server?  Jennifer 0 reply
IT sector How Switch (select or use) to a database? Jennifer 0 reply
IT sector How to list or view all databases from the mysql server?  Jennifer 0 reply
IT sector How you will Create a database on the mysql server with unix shell? Jennifer 0 reply
IT sector How to do login in mysql with unix shell? Jennifer 0 reply
IT sector What are indexes? What are B-Trees? Jennifer 0 reply
IT sector Compare Data mining and Data Warehousing ? Jennifer 0 reply
IT sector What is Data mining ? Jennifer 0 reply
IT sector What is ETL process in Data warehousing? What are the different stages in “Data warehousing”? Jennifer 0 reply
IT sector What is Snow Flake Schema design in database? What’s the difference between Star and Snow flake schema? Jennifer 0 reply
IT sector What are Fact tables and Dimension Tables ? What is Dimensional Modeling and Star Schema Design ? Jennifer 0 reply
IT sector What are Data Marts? Jennifer 0 reply
IT sector What is Data Warehousing ? Jennifer 0 reply
IT sector   What is Data Warehousing ? Jennifer 0 reply
IT sector What is SQl injection ? Jennifer 0 reply
IT sector What is a View? Jennifer 0 reply
IT sector Can you explain the SELECT INTO Statement? Jennifer 0 reply
IT sector What are Aggregate and Scalar Functions? Jennifer 0 reply
IT sector What is a Sub-Query? Jennifer 0 reply
IT sector What is a Sub-Query? Jennifer 0 reply
IT sector What is the difference between “HAVING” and “WHERE” clause? Jennifer 0 reply
IT sector What is " Group by " clause? Jennifer 0 reply
IT sector What are cursors and what are the situations you will use them? Jennifer 0 reply
IT sector What is the difference between “UNION” and “UNION ALL” ? Jennifer 0 reply
IT sector What is the difference between DELETE and TRUNCATE ? Jennifer 0 reply
IT sector What is a self-join? Jennifer 0 reply
IT sector What is the default “-SORT ” order for a SQL? Jennifer 0 reply
IT sector How to select the first record in a given set of rows? Jennifer 0 reply
IT sector What is “CROSS JOIN”? or What is Cartesian product? Jennifer 0 reply
IT sector What are different types of joins in SQL? Jennifer 0 reply
IT sector  we have an employee salary table how do we find the second highest from it?   Jennifer 0 reply
IT sector Can you explain the between clause? Jennifer 0 reply
IT sector   What is the SQL " IN " clause? Jennifer 0 reply
IT sector What is order by clause? Jennifer 0 reply
IT sector Can you explain Insert, Update and Delete query? Jennifer 0 reply
IT sector What is Like operator for and what are wild cards? Jennifer 0 reply
IT sector   How do we select distinct values from a table? Jennifer 0 reply
IT sector What are DML and DDL statements? Jennifer 0 reply
IT sector   Have you heard about sixth normal form? Jennifer 0 reply
IT sector Can you explain Fourth Normal Form and Fifth Normal Form ? Jennifer 0 reply
IT sector What is denormalization ? Jennifer 0 reply
IT sector What is normalization? What are different type of normalization? Jennifer 0 reply
IT sector How many types of relationship exist in database designing? Jennifer 0 reply
IT sector What are E-R diagrams? Jennifer 0 reply
IT sector What is the difference between DBMS and RDBMS ? Jennifer 0 reply
IT sector What is SQL ? Jennifer 0 reply
IT sector What is JAVAdoc utility? Jennifer 0 reply
IT sector What is a StringBuffer class and how does it differs from String class? Jennifer 0 reply
IT sector What is the main difference between ArrayList / HashMap and Vector / Hashtable?  Jennifer 0 reply
IT sector In which package is the applet class located? Jennifer 0 reply
IT sector What are applets ? Jennifer 0 reply
IT sector What’s the use of JAVAP tool ? Jennifer 0 reply
IT sector How can we force the garbage collector to run? Jennifer 0 reply
IT sector What are Native methods in Java ? Jennifer 0 reply
IT sector What is the use if “instanceof” keyword ? Jennifer 0 reply
IT sector What are packages ? Jennifer 0 reply
IT sector How can we implement polymorphism in Java ? Jennifer 0 reply
IT sector How do you implement inheritance in Java? Jennifer 0 reply
IT sector  What is JIT (Just-in-Time) Compilation ?  Jennifer 0 reply
IT sector What is JVM? Jennifer 0 reply
IT sector What is the difference between sleep and wait? Jennifer 0 reply
IT sector What is the use of transient keyword? Jennifer 0 reply
IT sector What is garbage collection? Jennifer 0 reply
IT sector Describe the wrapper class in Java. Jennifer 0 reply