Answer Posted / anjali

select min(column_name) from table where column in(select
top n
column_name from table order by column_name desc)

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

1067

---

What does cursor do in sql?

971

---

What is percent sign in sql?

1215

---

What's the difference between a primary key and a clustered index?

947

---

What is multiple columns?

1002

---

Does mysql_real_escape_string prevent sql injection?

910

---

how to check server status with 'mysqladmin'? : Sql dba

1018

---

How do rank () and dense_rank () differ?

977

---

What are the different types of a subquery?

984

---

How do I view a view in sql?

890

---

How many joins can you have in sql?

881

---

explain the difference between bool, tinyint and bit. : Sql dba

939

---

What is a recursive stored procedure?

1098

---

Is pl sql and postgresql same?

1058

---

How to test for null values?

985

---