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

1209

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

4 4440

why we are join a tow table

1 1949




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 3816

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 2737

how to know the tables in database having foreign key?

2 2670

Difference between MYSQL_ASSOC,MYSQL_NUM and MYSQL_BOTH ?

TCS,

3 18438

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

1801




what is the size of date datatype in sql?

2 3119

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

4 3332

What is the use of indexing table?

2 4407

what is the difference between MyIsam and InnoDb engine?

2 4637

how fastest access of data can be done from database ?

3 2964

what is the querry for all managers salary?

2 2466

how to find max salary from the database

3 3600


Post New MySQL Questions






Un-Answered Questions { MySQL }

What is a data directory?

41


Which is faster mongodb or mysql?

45


What are the objects can be created using CREATE statement?

95


How do I select a database in mysql workbench?

31


What is a session in mysql?

35






What is blob storage?

39


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

71


What is mysql command line?

39


What is dump in mysql?

46


Is mariadb faster than mysql?

29


How do I create a database in mysql workbench?

26


How do I run mysql on a mac?

40


What is mysql installer?

39


What is the difference between mysql_fetch_assoc and mysql_fetch_array?

30


How to check if value already exists in mysql database in php?

41