MySQL Interview Questions
Questions Answers Views Company eMail

Hi Team, This is kartik, I recently completed my B-tech. Importance of posting this question is for to know the best books on SQL(MYSQL/Oracle)? I like SQL concept's so much, at the same time i decided to choose SQL for my career purpose. So please suggest me the best books that are very helpful for a fresher to improve concepts like (SQL/PLSQL)Basics, programming concepts, architectures etc. Please consider my request as an important one. I am very thankful to you for providing this opportunity. If possible can you please send the names of books for my personal id also: karthikgdv1206@yahoo.com. Thanks, Kartik T

1156

how to find 2nd highest salary in random database salary of employer.....

4 4314

why we are join a tow table

1 1873




I have a table like this tblData (month int,Qty int) and i am inserting three rows in this table 1.tblData Values (1,100) 2.tblData Values (2,200) 3.tblData Values (3,300) The Result I want is the Running total of the field Qty that is 1 100 100 2 200 300 3 300 600 What is the Query for that ?

4 3673

mysql> select * from store; +------+-------+-------+ | id | month | sales | +------+-------+-------+ | 1 | 1 | 100 | | 1 | 2 | 100 | | 1 | 3 | 200 | | 1 | 4 | 300 | | 1 | 5 | NULL | | 1 | 6 | 200 | | 1 | 7 | 800 | | 1 | 8 | 100 | | 1 | 9 | 240 | | 1 | 10 | 140 | | 1 | 11 | 400 | | 1 | 12 | 300 | | 2 | 1 | 300 | | 2 | 2 | 300 | | 2 | 3 | 300 | | 2 | 4 | 200 | | 2 | 5 | 200 | | 2 | 6 | 200 | | 2 | 7 | 100 | | 2 | 8 | 100 | | 2 | 9 | 300 | | 2 | 10 | 100 | | 2 | 11 | 150 | | 2 | 12 | 150 | +------+-------+-------+ this is my table. i need to display output like this. +------+----------+----------+----------+----------+ | id | quarter1 | quarter2 | quarter3 | quarter4 | +------+----------+----------+----------+----------+ | 1 | 400 | 500 | 1140 | 840 | | 2 | 900 | 600 | 500 | 400 | +------+----------+----------+----------+----------+ what single query i have to write for this. i tried this query and it displays like the below mysql> select id,sum(sales) as quarter1,(select sum(sales) from store where mont h>3 and month<7 ) as quarter2,(select sum(sales) from store where month>6 and mo nth<10)as quarter3 from store where month>0 and month<4 group by id; +------+----------+----------+----------+ | id | quarter1 | quarter2 | quarter3 | +------+----------+----------+----------+ | 1 | 400 | 1100 | 1640 | | 2 | 900 | 1100 | 1640 | +------+----------+----------+----------+ 2 rows in set (0.00 sec) tel me how to rectify it.

2 2640

how to know the tables in database having foreign key?

2 2568

Difference between MYSQL_ASSOC,MYSQL_NUM and MYSQL_BOTH ?

TCS,

3 18093

using primary can we relate two table, with out foreign key?

1738




what is the size of date datatype in sql?

2 3021

What is the diff. bwt. primary key and unique key?

4 3230

What is the use of indexing table?

2 4296

what is the difference between MyIsam and InnoDb engine?

2 4552

how fastest access of data can be done from database ?

3 2827

what is the querry for all managers salary?

2 2346

how to find max salary from the database

3 3464


Post New MySQL Questions






Un-Answered Questions { MySQL }

Why do we use group by and order by function in mysql?

9


i made a table whih contain a column "Photo" with image data type and i want to insert the byte of a picture present in my hardisk using insert statement in that colum... so what will be my insert statement?

1588


What is triggers?

8


What is the purpose of -> in the mysql terminal?

16


write a query to mysql in safe mode and to change the root password

11






What are the differences between char and varchar data types?

9


Tell us something about heap tables?

13


Write a command with which mysql table can be repaired

11


List data types in mysql? Explain

9


How can you count the total number of records of any table?

9


What are date and time data types in mysql?

9


How to get help information from the server?

11


How many ways we can retrieve the date in result set of mysql using php?

28


What are the drivers in MySQL?

27


How to install mysql?

8